I’ve been tasked with coming up with a means of translating the following data: date category amount 1/1/2012 ABC 1000.00 2/1/2012 DEF 500.00 2/1/2012. How to make a dynamic PIVOT on multiple columns The problem of transposing rows into columns is one of the most common problems discussed in MSDN Transact-SQL forum.Many times the problem of creating a dynamic pivot comes into the light. SQL Server Programming FAQ, best practices,…