MS SQL Server 2008
How do you script via a Stored Procedure the following:
DB 1 - Table 1A (server A)
DB 2 - Table 2A (server B)
if DB 1 - Table 1A (column1) - unique value (uniqueidentity) doe not exist in
DB 2 - Table 2A (column1) - unique value (uniqueidentity) then create it in DB 2 - Table 2A
then copy certain columns from DB 1 - Table 1A to DB 2 - Table 2A (insert a new entry).
(there could for example none, 1 or 1000's of new table entries to create/insert each time stored procedure is called)