How to query case with crosstab in SQL Server

It is believed that many inexperienced people don't know what to do about how to query case in crosstab in SQL Server. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

The code is as follows:

The structure of the table landundertake is as follows:

The structure of the table appraiser is as follows:

Access code: the copy code is as follows: First SELECT Appraiser.quarterId of TRANSFORM First (Landundertake.valuerId) AS valuerId, Landundertake.landCode FROM Landundertake INNER JOIN Appraiser ON (Landundertake.valuerId = Appraiser.valuerID) AND (Landundertake. QuarterId = Appraiser.quarterId) GROUP BY Appraiser.quarterId, Landundertake.landCode PIVOT Landundertake. Valuer

SQL server code: copy code is as follows: select dbo.appraiser.quarterID,dbo.landUndertake.landcode,case dbo.landUndertake.appraiserGrade when 'appraiserID1' then dbo.landundertake.appraiserID else null END as appraiserID,case dbo.landUndertake.appraiserGrade when' appraiserID2' then dbo.landundertake.appraiserID else null END as appraiserID1 from dbo.LandUndertake inner join dbo.Appraiser ON dbo.LandUndertake.quarterID=dbo.appraiser.quarterID and dbo.landundertake.appraiserID=DBO.Appraiser.appraiserID Group by dbo.appraiser.quarterID,dbo.landUndertake.landcode,dbo.landundertake.appraiserGrade,dbo.landundertake.appraiserID

After reading the above, have you mastered the method of how to query case in crosstab in SQL Server? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!