Append data to the Existing Data table


#1

Hi Team,

I have written a select query. which will move data from old Datatable to new created data table.

While making a loop the new Datatable is replaced with new data of select query.

Instead of replacing i need to append it in the new datatable. Please provide your suggestions.


#2

Use a third datatable

originalDT, NewDT and tempDT. Select into the tempDT and merge into the NewDT after select completes. Then after each cycle the data is preserved in the newDT and overwritten in the temp