cancel
Showing results for 
Search instead for 
Did you mean: 

common table expression and table valued function

dov_luft3
Explorer
0 Kudos

Hello;

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

thanks

Dov

View Entire Topic
Johan_H
Active Contributor
0 Kudos

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