How to Pivot table in SQL Server?

Question

I have a table that currently looks like what is below. I'd like to only have one row per date and then have each EditType value be a separate column with the count so I can easily view the different types of edits based on the day. Can this be done using a pivot?

Or... would it be better to back up a step before I've grouped the rows in order to get the counts, like what is shown below?

The desired output would be something like this:

There are several `PIVOT` examples. What have you tried so far? — SS_DBA, Oct 12 '17 at 18:05

score 7 · Accepted Answer · answered Oct 12 '17 at 19:07

7

SELECT 
    Gdb
,   Tbl
,   EditDate
,   [I]
,   [U]
,   [D]
FROM #TABLE
PIVOT (
    COUNT(EditType)
    FOR EditType IN ([U], [I], [D])
) AS PIVOTED

answered Oct 12 '17 at 19:07

Denis Luiz

169
6

How to Pivot table in SQL Server?

1 Answers1