Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Sync Procedure

Author  Topic 

parikhm3
Starting Member

12 Posts

Posted - 2007-07-23 : 16:01:51
how do i write a sync procedure that syncs both tables and ensures that Table_2 keeps all services that are listed in Table_1

how do i write a procedure for the sync between both tables, and put this procedure into the package

so basically there have to be two sync parts: First is INSERT of what is not yet existing, second one is UPDATE on the appropriate attributes.

How would i write this sync procedure?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-07-23 : 16:21:11
dup. already answered here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86763

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -