PIVOT Equiv in T-SQL??
Posted on 1997-11-20
Is there a comparable function to Access's PIVOT?? I would like to sum all
the records by employee location by Job Title, where i'd be doing a group by Job Title and pivot on Location;
JobTitle LocationA LocationB LocationC Total
Job01 22 22 33 77
Job02 11 10 10 31
ANy help is appreciated greatly..................