Posts

Showing posts from February 27, 2011

Get all nested subcategories or data from a table in sql server

Get all nested subcategories or data from a table in sql server Consider the situation- ID      Name                 PID 1       a                         0         2       -a.a                     1 3       --a.a.a                2 4       --a.a.b               2 5       ---a.a.b.a           4 6...