Find difference between two data sets

• SqlServerNinja

  Ten Centuries

  Points: 1238

  More actions

  March 21, 2013 at 3:16 pm

  #271909

  Hello everyone.

  I have a query that I made on the database the output of which is say for example

  Id

  1

  2

  3

  4

  5

  I then made changes to the Database.

  I ran the same query . This time I get

  Id

  1

  3

  5

  I would like to know if there is a way of finding the missing Id's in the second query.

  My query outputs more than 11000 rows.

  Thanks

  L&P

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 21, 2013 at 3:18 pm

  #1599606

  Look at the EXCEPT operator. You need to be able to generate both results sets in order to compare them.