Thank you. do you have any example or article that i can follow to setup ??

Awesome. Thank you. I need to use left join for my sql statement for pivot. Any other article that can help me with complicated SQL statement ???

Here is...

Thank you all for your prompt reply. I think I was not clear initially with my questions. End user has requested to count of all the product information...

Existing excel need to be updated daily basis with addition of date column.

CaseType 09/10 09/11 09/12 09/13...

Thank you for your prompt reply.

here is my SQL statement which am running on daily basis to get count. End user wants information in format which i posted earlier.

SELECT...

voila. it worked thank you all.

Apperciate your help.

Thank you. It worked.

Here is Pdf document for golder book

Editor: LInk removed.