Advertisement
snargledorf

Find row differences between two sql statements

Dec 7th, 2011
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1. SELECT * INTO #temp FROM YOURTABLENAME WHERE YOURWHERECLAUSE
  2. SELECT * FROM YOURTABLENAME
  3. WHERE NOT EXISTS (SELECT * FROM #temp WHERE #temp.ID = YOURTABLENAME.ID)
  4. DROP TABLE #temp
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement