Well Jack,

You might wanna have a look at this stored procedure that I had written a few months back......similar to what you were trying to achieve......

http://www.sqlservercentral.com/scripts/insert+script+generator/65407/

Using the above sp that I have written you could generate for multiple tables all at once , just pass the table names in a concatenated fashion......and oh by way it also supports all datatypes i.e to say the insert script would be generated taking into consideration the datatypes......except for the sql_variant datatype.......

ohh did I mention it cares of the single quotes too.......:cool:

Cheers

Linson Daniel