Thanks for the reply. Sorry for the post but it can be answered by mssql since im still checking what will be the best sql server for the program.

Im...

Hi,

Can you please check my code since I'm having syntax problem based on dynamic pivot table I read.

Error is:

Msg 102, Level 15, State 1, Line 26

Incorrect syntax near '8'.

DECLARE @listCol...