Skip to content

Instantly share code, notes, and snippets.

@mikebeaton

mikebeaton/SqlDataComparison_Gist6.sql

Created April 11, 2020 13:47
Show Gist options
  • Save mikebeaton/da99c0d186df510f51227796909f1642 to your computer and use it in GitHub Desktop.
Save mikebeaton/da99c0d186df510f51227796909f1642 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SqlDataComparison_Gist6.sql
INSERT INTO dbo.AddressTypes (
[AddressTypeID],
[AddressType]
)
SELECT
[theirs].[AddressTypeID],
[theirs].[AddressType]
FROM dbo.AddressTypes [ours]
FULL OUTER JOIN RemoteServer.CustomerDatabase.dbo.AddressTypes [theirs]
ON [ours].[AddressTypeID] = [theirs].[AddressTypeID]
WHERE [ours].[AddressTypeID] IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment