wallice
Member
Hi All,
i need to convert all my cursor based stored procedures to CTE based stored procedures.
As CTE (common table expressions) as much faster and reliable than cursors. I would like to replace all my stored procedures that use cursors with CTEs to improve query speed.
Any ideas how to implement it.
Appreciate your time.
Thanks.
hammingcode
Member
Is it possible to define multiple query definition for recursive CTEs(common table expression).
I am using a complex query using CTE to show product channel hierarchy where i have two CTE definition i.e. one for product information and other for channel information.
And the hierarchy is there in the channel information (base channel, sub channel).
Any help will be great.
You must log in to post.
