[font="Verdana"]I suspect the answer is: "because".

I do know they've got some improved syntax for doing multiple row inserts in SQL Server 2008, so there the "issue" goes away.

I also know if you use the UNION ALL syntax, you can embed the same SELECT statement as part of a CTE or a derived table/in-line view. You can't do that with a whole bunch of INSERT statements.

And I also know if you do the insert with UNION ALLs, it will generate one transaction rather than multiple transactions. Sometimes that's what you want.

But for how you are using it, a whole bunch of inserts is fine.

[/font]