Process Records With Field Values That Are Missing From Another Table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I need to scan each record in the table tblTestCodeFavorites to ensure the value in the field TestCode exists in the table testCodes. If the value in tblTestCodeFavorites.TestCode does not exist in testCodes.SomeField, then I need to perform some processing on that tblTestCodeFavorites record (or records).

Posted 28-Apr-11 6:24am

stevenandler

Updated 28-Apr-11 6:58am

AspDotNetDev

v2

Add a Solution

Comments

Corporal Agarn 28-Apr-11 12:29pm

I suggest you
1) rewrite the title
2) rewrite the question
3) show what you have tried

Hint JOIN

AspDotNetDev 28-Apr-11 12:59pm

I updated your question to have a more succinct title and a more descriptive explanation. Please add any code you've tried and ask a specific question about the problem you are having. Right now you are asking us to give you code... we need to see that you've already tried to do this yourself.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Accepted Answer · 2011-04-28T12:07:00

Solution 1

SQL

SELECT tcf.*
FROM tblTestCodeFavorites tcf
    LEFT JOIN tblTestCodes tc ON tcf.TestCode = tc.SomeField
WHERE tc.SomeField IS NULL;

Above SQL statement will fetch you all the records in table tblTestCodeFavorites that don't have values in column TestCode that would match column SomeField in table tblTestCodes. Loop through these rows and do whatever processing your heart may desire.

Best Regards,

-MRB

Posted 28-Apr-11 12:07pm

Manfred Rudolf Bihy

Comments

stevenandler 29-Apr-11 15:21pm

Thank you Manfred. This works great!

Manfred Rudolf Bihy 2-May-11 6:40am

You're welcome!