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