Skip to Content
0

common table expression and table valued function

Nov 21, 2017 at 03:28 PM

36

avatar image
Former Member

Hello;

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

thanks

Dov

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Johan Hakkesteegt Nov 22, 2017 at 07:45 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded