In this article you will learn how to pass a table to a stored procedure in SQL Server using table valued parameters.
SQL Server 2012 Functions Recipes