Ask - Is there any way to insert n same rows distinguished by an identity column without using loop

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

Is there any way to insert n same rows distinguished by an identity column without using loop

Dec 29 2011 4:25AM by satyajit

Hi, I have col1 , col2,col3 ,col4 variables. They wil fill up 1 row in a table. I want to insert them say 20 times in the table.Is there any way without using loop?

Thanks, Satyajit

Submitted under: · · · ·

satyajit

124 · 1% · 402

2 Replies

here number of rows to insert is dynamic...

commented on Dec 29 2011 4:42AM

satyajit

124 · 1% · 402

Try this link

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/74d4027c-525d-474c-9d10-bb4b62e86d1c

commented on Dec 30 2011 6:03AM

Mitesh Modi

18 · 10% · 3078

Your Reply

Sign Up or Login to post a comment.