Boddam

Naom

SQL Server 2005 and down

insert into table (ID) select '1' union select '2' union select '3'

SQL Server 2008

insert into table (ID) values ('1'), values ('2'), values ('3')

cool, thanks! What if I want to use a parameter, like "insert into table (ID) values @myValues". is that possible or waste of time trying..?

better look at here http://forums.asp.net/p/1475397/3430735.aspx#3430735