[Quote]

INSERT INTO test(col1, col2) VALUES

( @param1, @param2),

( @param1, @param2),

( @param1, @param2),

( @param1, @param2),

( @param1, @param2)

[/Quote]

How you are saying that the above and

[Quote]

INSERT INTO test(col1, col2) VALUES( @param1, @param2)

INSERT INTO test(col1, col2) VALUES( @param1, @param2)

INSERT INTO test(col1, col2) VALUES( @param1, @param2)

INSERT INTO test(col1, col2) VALUES( @param1, @param2)

INSERT INTO test(col1, col2) VALUES( @param1, @param2)

[/Quote]

are same when i am issuing a loop for each and every record

While i<=2

Begin

INSERT INTO test(Col0, col1, col2) VALUES( i,@param1, @param2)

Set @i=@+1

End

which means that the loop value is incremented and same need to be stored and not as you stated right?

Thanks!