How to change this Access TRANSFORM statement to Sql Server
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? 

    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;
How to change this Access TRANSFORM statement to Sql Server
===

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? 

    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;