common table expression and table valued function

[dov_luft3]

Hello;

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

thanks

Dov

[Johan_H · Accepted solution]

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