Hi SSCRAZY,

I am very new to SQL Stored procedure.I did not understand the second wasy of doing using filters.

I did not understand where we are inserting the dataset to input paramter p_name1.

Can you please provide me a sample procedure for using filters.

Also, regarding the first approach using table-value.I have created a type but do we need to create a temporary table also for that to insert the values in the table? for every execution of stored procedure, this table will created and deleted after executing ?