You can't pass table variables into functions or sprocs.

BOL:

"The nonscalar types cursor and table cannot be specified as a parameter data type in either Transact-SQL or CLR functions.

"

Hi Gregory,

What is the comparative performance of the ISNULL() ... against the OR columnname is NULL

Thanks for a great article!

Rick,

I agree with that statement, so I add a caveat. Having taken into consideration all the implications for performance, I use this method when dealing with small result domains...

Another approach I have been using this year to the issue of dealing with parameters is to use table variables to store the filtered selections. In the absence of a...