SQLTeam.com | Weblogs | Forums

Records count

I need to count the different total number of records from the table as table has column which contains records in hierarchic way.

Ex. Column name: CatName, which contains data like Catalog, Doc, Folder, Files. When it's design into portal as below.

Catalog ==> IT, HR, FIN, Legal

Now under IT, it has another Folder and Document and files like: Network, DR and each contains files

So I need to count how many IT records then under IT, how many Folder, then under each folder , how many files.

I hope i have clear instruction what i want it,.

Flow Hierarchi is kind of shown in image (it;s not Perfect)

Kindly post the table structure with sample data

1 Like


hope this link helps ....you have good enough english language skills to understand ..


Thanks Harish.
I will check it out,