>>If we're using SQL Server 2008 and up, then why not pass the @tableList directly from .NET application?
>
>This sounds interesting. Can you elaborate more on this?

I haven't tried myself, but there are a lot of blogs explaining how to use Table Valued Parameter from .NET code. You may want to google on 'TVP SQL Server VB.NET'. I liked that one when I saw it

http://lennilobel.wordpress.com/2009/07/29/sql-server-2008-table-valued-parameters-and-c-custom-iterators-a-match-made-in-heaven/