>Hi folks - just wondered if anyone knew of an equivalent MS SQL command to this RDB SQL command...
>
>INSERT INTO table (field1, field2, field3) VALUES (fixed, fixed, var1) VARYING (var1 [1-52])
>
>This makes one statement do 52 inserts...
>
>Any ideas?
Not exactly, but you can do a multiple row insert by specifying a select statement instead of the VALUES(). Combining this with an existing table, an identity column and the TOP clause you can get close to the same effect:
Insert Into table
Select Top 52 'something1' as fixed, 'something2' as fixed2
From myExistingTable
The existing table would need to have the number of rows specified after the TOP clause, and the target table would need to have the identity field defined (var1 in your example). Unfortunately you would not control the sequence on the identity field by going this way unless you clear the table of rows first with TRUNCATE TABLE.
Just a wild idea.