sql server - Show Sale Data By Salesman By Region -
i need sql server query show grid of sales region sales person this: region mitchell mark manny moe ----------------------------------------- west 0 0 0 0 north 0 1 1 1 east 1 0 0 0 south 0 0 0 0 how can have sql query output data this? know use return data not in correct breakdown or format. select region, salesperson, count(sales) salesdatabase group region, salesperson you can pivot table. try this: ;with data ( select region, salesperson, sales salesdatabase ) select region ,[mitchell] ,[mark] ,[manny] ,[moe] data d pivot (count(sales) salesperson in ([mitchell], [mark], [manny], [moe])) p; you can find more information here .