Community

SQLServer: Dynamic Cross-Tab

(Muthusamy Anantha Kumar) Producing a cross-tab report with static number of columns is a straightforward process. When comes to the dynamic number of columns, it gets tricky. This article illustrates how to generate a cross-tab query on the fly, using the EXEC statement and simple string concatenat

Read More - Register for Free Membership