Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
PRINT 'Items which are in TDS but not in Unicorn'
select tds.ID as 'TDS ItemId',
unicorn.ID as 'Unicorn ItemId'
from [tds910_Master].[dbo].[Items] as tds
left join [unicorn910_Master].[dbo].[Items] unicorn
on tds.ID = unicorn.ID
where unicorn.ID is null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment