Posted by rhaazy on 06/30/06 18:32

ah ahaha all I needed to do was this...
use my normal insert statement and add a where clause to the end of it
like this..

UpdateTblScanDetail....

Insert into TblScanDetail
where #temp.ID not in (select GUIID from tblScanDetail)

doh! way too simple....

• Next in forum: Re: inserting into two tables and transaction problem
• Prev in forum: Re: Update statement, then insert what wasn't available to be updated.
• Thread view: Re: Update statement, then insert what wasn't available to be updated.

[Reply to this message]