Thursday, March 8, 2012

Conditional insert

Hi All,
I think I am a little dense when it comes to understanding SSSI. I want to insert into a table (a) with data from a table (b) located on a different server where the data data from table (b) does not exist in table (a).
I know how to create the sql command but, exactly where does the command belong.
I don't see how or where the command should be.
Also, after the above insert I want to use the same data selected and insert into various other tables.
I have not been able to resolve this and any help is certainly appreciated.
Thanks,
RoyCheck this out:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=119489&SiteID=1

No comments:

Post a Comment