title: How to Pivot table in SQL Server?
body: <p>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?</p>
  
  <p><a href="https://i.stack.imgur.com/AgJY3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AgJY3.png" alt="enter image description here"></a></p>
  
  <p>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?</p>
  
  <p><a href="https://i.stack.imgur.com/2Q1yr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2Q1yr.png" alt="enter image description here"></a></p>
  
  <p>The desired output would be something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/TCcSU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TCcSU.png" alt="enter image description here"></a></p>