This is my first post!I'm in serious need of help, I have a query that works, it produces this:UserID UserName GMC Buick Used1 Jesse 1 2 12 Mark 4 3 2But I need to pivot it, so that it appears this way Jesse MarkGMC 1 4Buick 2 3Used 1 2Here is my current query, I'm having a hard time with changing it to a pivot because I can't figure out what the aggregate function needs to be. declare @Param1 date = '12/1/2012',@Param2 date = '12/31/2012'Select Users.UserID, Users.UserName, [GMC] as GMC, [Buick] as Buick, [Used] as UsedFrom (UsersLeft Outer JOIN(SELECT UserName, Users.UserID, COUNT(Sales.Make) As GMCFROM SalesJoin SalesUsers On Sales.SaleID = SalesUsers.SaleIDJoin Users On SalesUsers.UserID = Users.UserIDWHERE (Sales.PreOwned = 0) And (Sales.Make = 'GMC') AND (Sales.SaleDate <= @Param2) and (Sales.SaleDate >= @Param1)Group By UserName, Users.UserID)GMCCountON Users.UserID = GMCCount.UserIDLeft Outer JOIN(SELECT UserName, Users.UserID, COUNT(Sales.Make) As BuickFROM SalesJoin SalesUsers On Sales.SaleID = SalesUsers.SaleIDJoin Users On SalesUsers.UserID = Users.UserIDWHERE (Sales.PreOwned = 0) And (Sales.Make = 'Buick') AND (Sales.SaleDate <= @Param2) and (Sales.SaleDate >= @Param1)Group By UserName, Users.UserID)BuickCountON Users.UserID = BuickCount.UserIDLeft Outer JOIN(SELECT UserName, Users.UserID, COUNT(Sales.Make) As UsedFROM SalesJoin SalesUsers On Sales.SaleID = SalesUsers.SaleIDJoin Users On SalesUsers.UserID = Users.UserIDWHERE (Sales.PreOwned = 1) AND (Sales.SaleDate <= @Param2) and (Sales.SaleDate >= @Param1)Group By UserName, Users.UserID)UsedCountON Users.UserID = UsedCount.UserID)