How to find missing record's in sqlserver

Question

1.80/5 (2 votes)

See more:

I have two tables...let's say tableA and tableB when I dumped the data from tableA to tableB some record's are missing...
How to see the missings record's...
Can anyone help me with this by a SQL query...

What I have tried:

I tried JOINS like left join but I didn't get it

Posted 10-Oct-18 22:16pm

Member 13932549

Updated 11-Oct-18 1:24am

CHill60

v4

Add a Solution

Comments

OriginalGriff 11-Oct-18 4:51am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
So perhaps some sample data input, the query you used, and the expected and actual; results would help?
Use the "Improve question" widget to edit your question and provide better information.

Mohibur Rashid 11-Oct-18 5:19am

Is there any unique Id?

#realJSOP 11-Oct-18 7:08am

If they're missing, they cannot be found. This is SQL zen.

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)

Richard Deeming · Answer 1 · 2018-10-11T01:24:00

Solution 1

To find the records in table A which are not in table B:

SQL

SELECT
    ... Columns ...
FROM
    TableA

EXCEPT

SELECT
    ... Columns ...
FROM
    TableB

You'll need to select the same columns from both tables.
EXCEPT and INTERSECT (Transact-SQL) | Microsoft Docs[^]

Posted 11-Oct-18 1:24am

Richard Deeming

Comments

Maciej Los 14-Oct-18 16:55pm

5ed!