Hi

many thanks for your help. There is no SSRS, hence I am trying to do it in T-SQL so that they can run it and export to excel.

Thanks

Hi Luis,

Thanks for all the troubles. Again here is my scripts. can this be used to achieved the sample report I sent earlier on. Do I need cross join to...

Hi Luis,

Thanks for the help.Maybe is me not explaining myself very well. However, that is exactly what I need as in the sample report. Can you please help me to...

Please see the attached image/sample report

Many thanks to you and others who have contributed sofar. In the Month column, it displays avg but what I want is the percentages like 90% and so on. Basically,...

Thanks for your advice and timely reply.

Please see the sample of my dataset below and would happy if you help me with a pivot or grouping set you mentioned earlier...

Thanks for your advice and timely reply.

Please see the sample of my dataset below and would happy if you help me with a pivot or grouping set you mentioned earlier...

Thanks for your advice and timely reply.

Please see the sample of my dataset below and would happy if you help me with a pivot or grouping set you mentioned earlier...