SQL Server 2005 Script Help
Posted on 2013-10-29
I have two tables that have similar information but in two different environments and one is current, but the other isn’t; however, like to use the records on one by scheduling a job to always update the other table using the information from the table that is current.
How you achieve this in SQL Server 2005 since it has no merge statement? Some help here.
See my columns (both tables have same columns)