I want to find out the total number of items in a particuler location

Narendar_Reddyk

I want to find out the total number of items in a particuler location but

1. The location has 3 sub folders, ex: A, B and C
2. I want to exclude the total number of items from C, want the total number of items from A and B only

I can use Dtreeancestors but how to exclude folder C ?? (We are using SQL Server and it is 9.7.1)

Can any help on this would be greatly appreciated

John Simon

select count(dataid) from dtreeancestors where ancestorid = ParentFolder and dataid not in (select dataid from dtreeancestors where ancestorid = FolderC)

Cheers...