--WATERFORD --Backup Table you are working on first SELECT * INTO [TABLE_BACKUPS].[dbo].[WATERFORD_BOCClientIndex - FAF_180522_V1] FROM [OLIS_DATA_CLARE].[dbo].[BOCClientIndex - FAF] --Add missing column ALTER TABLE [OLIS_DATA_WATERFORD].[dbo].[BOCClientIndex - FAF] ADD NAME_OF_UNIT NVARCHAR(50) NULL --Update missing column with values from table with the Columns and data UPDATE [OLIS_DATA_WATERFORD].[dbo].[BOCClientIndex - FAF] SET [NAME_OF_UNIT] = t2.[NAME_OF_UNIT] FROM [TABLE_BACKUPS].[dbo].[WATERFORD_BOCClientIndex - FAF] t2 INNER JOIN [OLIS_DATA_WATERFORD].[dbo].[BOCClientIndex - FAF] t1 ON t2.[FAFID] = t1.[FAFID];
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter