Recursion in stored procedure. | SQL Server Performance Forums

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.
e.g.
Category
Category1.1
Category1.1.1
Category1.2
Category1.2.1
Category1.2.1.1
Category1.3
http://www.informit.com/articles/article.asp?p=25288&seqNum=13&rl=1
http://articles.techrepublic.com.com/5100-9592_11-5700193.html Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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.
]]>