Skip to Content
avatar image
Former Member

common table expression and table valued function

Hello;

Is there a way to makes use of Common Table Expression or table values function in generation queries in SBO ?

thanks

Dov

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 22, 2017 at 07:45 AM

    Hi Dov,

    To my knowledge this is possible, but I recommend you make sure by testing a simple query in a test database.

    Please note that you would have to create a Table-valued function in MS SQL Management Studio, and that such user defined functions and stored procedures may be deleted during a system upgrade. So remember to save a backup of your database.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded