We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
MERGE INTO [Movies] As [target] USING (SELECT [Dbid], [Status], Studio, Released, Sound, Versions, Price, Rating, [Year], Genre, Aspect, UPC, DVDReleaseDate, [TimeStamp], Name FROM MoviesStaging) AS source ON ([target].[Dbid] = source.[Dbid]) WHEN MATCHED THEN UPDATE SET Name = source.Name, [Dbid] = source.[Dbid], [Status] = source.[Status], Released = source.Released, Sound = source.Sound, Versions = source.Versions, Price = source.Price, Rating = source.Rating, [Year] = source.[Year], Genre = source.Genre, Aspect = source.Aspect, UPC = source.UPC, DVDReleaseDate = source.DVDReleaseDate, [TimeStamp] = source.[TimeStamp] WHEN NOT MATCHED THEN INSERT ([Dbid], [Status], Studio, Released, Sound, Versions, Price, Rating, [Year], Genre, Aspect, UPC, DVDReleaseDate, [TimeStamp], Name) VALUES (source.[Dbid], source.[Status], source.Studio, source.Released, source.Sound, source.Versions, source.Price, source.Rating, source.[Year], source.Genre, source.Aspect, source.UPC, source.DVDReleaseDate, source.[TimeStamp], source.Name);
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.