eh.shams (9/17/2012)
would you please be more specific , or let me know with example ?Thanks
e.g. in Source and Destination table CustID is unique number then we can have below query to insert only new records
INSERT INTO dest_tbl (Col1,Col2, .....)
SELECT Col1,Col2, FROM sorce_tbl
WHERE NOT EXISTS (SELECT CustId FROM dest_tbl )
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂