>>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