Passing table valued parameters in SQL Server 2008
August 28, 2007[From TechRepublic]
I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary.
I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.
The article continues at http://blogs.techrepublic.com.com/datacenter/?p=168