Here Try this one - It EXCLUDES high level Folders but does differentiate all the ones that do not match their respective parents.

SELECT (SELECT DISTINCT policyid FROM [EOC-RPTSQLP01].[ReportServer].[dbo].catalog WHERE parentid...

• This reply was modified 2 years, 4 months ago by  dkangel.
• This reply was modified 2 years, 4 months ago by  dkangel.