Last post Aug 02, 2011 06:46 AM by nermeen
Jul 31, 2011 07:08 AM|nermeen|LINK
i have a table(Sectors) with the structure
Sec_Parent F.K(self join)
i want to show the data in the report with the hierarchy
level2(child of parent1)
level2(child of parent2)
Jul 31, 2011 12:08 PM|Shuvo Aymon|LINK
you can do it with recursive CTE. please follow the links
Aug 02, 2011 03:09 AM|nermeen|LINK
Thanks for your reply,
But actually iam using SqlServer2000 and i didn't find recursive CTE on it.
Aug 02, 2011 04:11 AM|Shuvo Aymon|LINK
Then I think you won't be able to use CTE. how many levels are there in your structure?
Aug 02, 2011 06:46 AM|nermeen|LINK
it is unlimited, it is dynamic