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: 240
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