Pivot Query SQL Server

Asked Apr 23 '13 at 12:13

Active Apr 23 '13 at 12:31

Viewed 166 times

How can I create a dynamic pivot table, the dynamic parameter is date in a month ( for example month = January, the pivot value date is from 1 until 31)

I only could make a non-dynamic query like this:

 SELECT
        *
    FROM
        (
            SELECT
                CollectorName,
                CountTask,
                dayTask,
                monthTask
            FROM
                #tempHistLoad
        ) DATA
        PIVOT
        (
            SUM(DATA.CountTask)
        FOR
            dayTask
            IN
            (
                [1],[2],[3],[4],[5]
            )
        ) PVT

how can I make a dynamic column (date from 1 to end of month) in pivot table?

edited Apr 23 '13 at 12:17

apomene

14,282
9
46
72

asked Apr 23 '13 at 12:13

Fransiska

1

Is it possible to pivot the data in your reporting/UI/application layer? – paul Apr 23 '13 at 12:16
2

I would just make it a static list of 31 days. Problem solved – RichardTheKiwi Apr 23 '13 at 12:20
http://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query https://www.simple-talk.com/blogs/2007/09/14/pivots-with-dynamic-columns-in-sql-server-2005/ – Nenad Zivkovic Apr 23 '13 at 12:41

Pivot Query SQL Server

0 Answers0