MS SQL view

$10-30 USD

Completed

Posted

over 3 years ago

$10-30 USD

Paid on delivery

I need a SQL View designed that will identify records which should NOT be in one table based off of another table. tbl_DOGS_PER_COMPANY - List of vendors and which dog breed they are allowed to sell tbl_RECORDS - lists each vendor and the dog breed they have sold recently I need a view that will show me ALL records in tbl_RECORDS listing the vendors who sold dogs NOT on their list. Example Vendor ID =3 is ONLY allowed to sell Breed ID=9. So ALL records in tbl_RECORDS where CompID=3 and DOGID does NOT=9 I want to see. Sample SQL file with tables and test data attached. Based on my file I believe the view should have 9 records

SQL

Microsoft SQL Server

Database Administration

Project ID: 28918480

About the project

6 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@hassannazeer

Hi, I am asp.net developer having more than 5 years of experience in SQL. I can create SQL view for your tables Let me know if you are interested. Thanks

$22 USD in 1 day

5.0

(3 reviews)

1.9

6 freelancers are bidding on average $19 USD for this job

@sumon355

Hello, As an expert in SQL and ms sql server, I am very much interested to provide you the required VIEW. Looking forward to have a positive response from you. Thanks

$24 USD in 1 day

5.0

(283 reviews)

7.8

@axiomswb

Hi there! I have expertise in SQL. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details.

$20 USD in 1 day

4.9

(20 reviews)

5.4

@MiniDeveloper21

Hi there I can do that task for you I am doing Software Engineering ,Having 2 years experience especially in programming (i.e. Java,C#,C++,C,Python), Data Preprocessing, Code Debugging, Database connections, App development and much more. thanks

$20 USD in 1 day

5.0

(27 reviews)

4.3

@keyurrathod

Dear Client, I am working on SQL Server since last 7 years. I have worked on like posted project. I would like to work with your project, if you will give chance to me. I would like to create demo for you. If you like it, then you can award project to me. Please ping me to create demo. There is no charge of demo. Thanks

$15 USD in 1 day