Finally SQL Server 2008 offers user defined tables as a parameter. I've been using Microsoft SQL server since version 6.5 and this has probably been the biggest annoyance. There are so many times that I want to send a batch of records to be acted on, and I can't, I've come up with many different solutions, but none of them have ever let me do what I really wanted.
Now with SQL Server 2008 I will finally be able to. If I can just get us to upgrade to it at work.
There's more information at InfoQ