Is there any limitations on how many With CTEs you can use in a Stored Procedure?
I have a SP which has 3 temp tables. I am trying to use With CTE instead of temp tables. The reason is to index them and have better performance.
Thanks in advance. Best Wishes, Arbi --- Please vote if you find this posting was helpful or Mark it as answered.
View Complete Post