We have found no need to impliment clr, For us, SQL is about returning SETS and although it takes a mind flip to stop thinking procedurally and start with set...

Oh and I find the topic a bit misleading, as I don't think its possible to send a table var when calling a stored procedure from (say) an aspx page....

But...

Interesting, Very interesting... In addition to the comments above I'd also take issue with your xml implementation.

<Product>

<ProductID>1</ProductID>

<ProductName>Chai</ProductName>

...