How to insert all the records of one table to the another table through stored procedure in MS SQL by using loop.



If the records reach to end of file then exit.

Max

You don't need a loop. You can use an Insert into statement...

 

check out http://www.tek-tips.com and look for their sql server forum.

 

 

Good Luck