Hi Scott

Nice article about a new technology that is way too less used till now (in my opinion).

@Phil_Factor

To send data from .NET client side to a table-valued parameter, you can use either a DataTable (I don't like this due to its huge overhead) or a IEnumerable<SqlDataRecord> (my preference).

Here's an article from SSC:

Streaming Data Into SQL Server 2008 From an Application[/url]

And here are further articles from my blog:

Table-Valued Parameters - A Performance Comparison

Table-Valued Parameters

Hope this helps

Flo