January 12, 2010 at 12:52 pm
Hi,
Is it possible to use a CTE within a User Defined Function? I have a CTE which works great but I want to be able to pass a variable to it and take the result and pass it back. Is this possible.
Thanks
January 12, 2010 at 12:53 pm
yes you can use a CTE and recursive CTE's in a function;
a lot of the Tally Table examples you'll find here do exactly that to build a Tally table dynamically, and then use it in the function for Splitting, parsing, etc.
Lowell
January 12, 2010 at 1:15 pm
Thanks got it to work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply