Records count

Transact-SQL
1

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,.

2

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

OpenText%20count%20flow
OpenText count flow.jpg810×1080 98.8 KB

3

Kindly post the table structure with sample data

1 Like
4

hi

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

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2520ca9d-a5d6-4f92-8abe-1fdd74465278/tsql-count-hierarchies?forum=transactsql

5

Thanks Harish.
I will check it out,