Note: When table variables are passed as parameters, the table is materialized in the tempdb system database rather than passing the entire data set in memory; this makes handling large amounts of ...

You can join to a UDF. Using table variables SQL Server 2000 has a new Table data type that lets you declare local variables as type table. The table type is available only via a UDF.

In my can Param1 and Param2. These parameters are being set with two variables, varValue1 and varValue2. The Stored procedure will return a table of data with two properties. R_ID and R_Description.