Transform-Pivot In SQL Server 2005

Is there any equivalent for Transform-pivot of MS Access in SQL Server 2005?

I have this query in MS Access that I need to migrate to SQL Server 2005


TRANSFORM Sum(CD1([CheckAmount]))
AS [The Value]

SELECT "Total
Amount of Checks" AS Type, tblResult.AccountNumber,
tblResult.CheckDate, tblResult.Status, Sum(CD1([CheckAmount]))
AS Total

FROM tblResult

GROUP BY "Total Amount
of Checks ", tblResult.AccountNumber, tblResult.CheckDate,
tblResult.Status

PIVOT IIf(IsNull([statusdate]),"Outstanding",Format([StatusDate],"Short
Date"));