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 1 year, 9 months ago by dkangel.
- This reply was modified 1 year, 9 months ago by dkangel.