How do I use the Pivot Command in SQL Server 2005. I have been looking at samples but I cannot Figure out what I am supposed to do with the two columns in the IN. I marked them as [...], [...] below.
vb Code:
SELECT [0], [1] FROM SELECT ServiceClassID, ServiceClassCode FROM vServiceClasses PIVOT (COUNT (ServiceClassID) FOR ServiceClassCode IN ([0], [1] ) AS pvt




Reply With Quote