title: How to change this Access TRANSFORM statement to Sql Server
body: <p>I need to convert this Access query to Sql Server but it looks like Transform and Pivot are not valid Sql Server functions. What is the equivalent function? Or would I have to rework the entire query all together? </p>
  
  <pre><code>TRANSFORM Sum([Rates by Quarter and Bedsize].[State CLABSI Rate]) AS [SumOfState CLABSI Rate]
  SELECT [Rates by Quarter and Bedsize].Bedsize
  FROM [Rates by Quarter and Bedsize]
  GROUP BY [Rates by Quarter and Bedsize].SizeCategory, [Rates by Quarter and Bedsize].Bedsize
  ORDER BY [Rates by Quarter and Bedsize].SizeCategory
  PIVOT [Rates by Quarter and Bedsize].SummaryYQ;
  </code></pre>