Updating table from another table
If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
I have to update "table2" from another "table1" located in another database.
) and the first row was already copied in yesterday's execution of the procedure but the second was only added today (the query above will skip copying the second row).
Progress Software Corporation makes no explicit or implied claims to the validity of this information.If you have an identity column in the transaction table I would use that as your test.Something like this: INSERT INTO [BDID_BI].[dbo].[Transaction] SELECT B.* FROM [BDID].[dbo].[hl_transaction] as B LEFT JOIN [BDID_BI].[dbo].[Transaction] AS B_BI ON B.primary Key = B_BI.primary Key WHERE B_BI.primary Key IS NULL; , what is the type of the column?Requirements : We need two tables with at-least a common field among them with same datatype.It is the field which we want to update with the value from the second table.
So when might you need to copy data from one table to another?