Here Mudassar Ahmed Khan has explained with an example, how to execute Stored Procedure with Table Valued Parameters in SQL Server.
First a Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter.
Then it is passed as Parameter to the Stored Procedure and the Stored Procedure is executed using the EXEC command in SQL Server.