Wednesday, March 21, 2012

Loop through Query

Out of one messed up table I need to create two related tables. I am stuck in trying to get 'some' of the columns from the messed up table to the new table.

How can I select only the columns I need and insert them in the new table?

Thanks in advance!

Hi There,

I done something similar to thi before and i found this article is helpful.

http://www.sql-server-performance.com/dp_no_cursors.asp

No comments:

Post a Comment