Thanks so much. After sleeping on it last night I finally got it to work. The problem lie within Reporting Services not the function. Thanks again!

What I am trying to accomplish is when I choose a parameter I need to pass the result into another parameter in order to limit the number of available selections....

Thanks Jeff for your help! Code working pretty well. Only issue I'm having is getting one parameter to be dependent on the other in a stored proc that populates a...

Thanks for the quick reply. Having a little trouble getting the order correct with the code. Get the declare and set statements to work but the CTE is tripping me...

I have used this code many times since I first read this article. Now, how do I create multiple variables within the same stored proc?