SQL Server Performance Forum – Threads Archive
Recursion in stored procedure.I need a Recursion in stored procedure.
I want a stored procedure which display the category in the tree structure.
http://articles.techrepublic.com.com/5100-9592_11-5700193.html Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
It depends on the data structure whether you need recursion or not. So show us the design of the table(s) from which this tree structure is drawn, and some sample data.