Description: Contains useful source codes in programming and solutions to various programming problems, either debugging or deploying problems
programming (6840) report (825) error (229) debugging (65) crystal report (4) asp.net programming (3) vb programming (3) deploying (2) programming error (1) debugging problem (1)
Slide description
In this post, I want to share SQL tips on how to create dynamic pivot table in SQL.
The columns in the pivot table is not fixed in this case. Hence, there is a need to use dynamic SQL to achieve this.