kapil_kk (12/18/2013)
Koen Verbeeck (12/18/2013)
kapil_kk (12/18/2013)
After data gets transferred change the status flag to 1 for those rows...
In which table? Table1 or table2?
in table1 from which I am transferring data..
Now it's clear.
Just use the UPDATE statement posted by Abu Dina. No staging table necessary.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP