Archive for tag: pivot

Using Dynamic Values in the PIVOT Operator

21 February, 2009 (10:20) | T-SQL | By: Mark V

I recently worked on a report for a client in which a date input parameter was used to determine the end dates of the previous four calendar quarters. Each time the report ran, it returned data for all four of those quarters. I ended up using PIVOT in the course of the stored procedure for […]