I need to insert multiple rows at once in sql server ..based on an iterative value

Posted by sajad on Stack Overflow See other posts from Stack Overflow or by sajad
Published on 2010-05-11T06:54:31Z Indexed on 2010/05/11 7:04 UTC
Read the original article Hit count: 242

Filed under:
|
|

Hi friends, I want to insert 3 rows at a time in a table based on select statement..

consider the query

insert into tblTemp 
(
a,b
)

select a, b from tblTemp2

This lets me insert one row in tblTemp..

my requirement is to add 3 rows with iterative values a,a+1,a+2 for each b inserted.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server