Using a CTE within a UDF

  • 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

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 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