| 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