The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
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);