Hi, where can I download the template? thanks

Thanks, nice improvement

i did some research

and this is what I found

WHEN C.type = 1 THEN '1-Folder'

WHEN C.type = 2 THEN '2-Report'

WHEN C.type = 3 THEN '3-File'

WHEN C.type = 4...

thanks for the correction

it would be

CASE Cat.Type WHEN 1 THEN 'Folder'

WHEN 2 THEN 'Report'

WHEN 3 THEN 'Resource'

WHEN 4 THEN 'Linked Report'

WHEN 5 THEN 'Data Source' ELSE ''...

it's a very simple script but it helps a lot

You are wellcome

I have a few others that works in the tuning department

hi

in the line

SET @strTableName = 't_DispCSV'

you should put the name of the table you want to analyze

SET @strTableName = 'TableNameToAnalyze'