I have tried and tried to get what I thought would be not so tough but I am stuck. I have a single table (Car Sales) and I simply want to know how many of each of the following a salesman sold: New Vehicles Vehicle Year Colors ('Blue', 'Red', 'Green') The relevant fields from the Sales table are: SalesmanID int IsNew bit VehicleYear char(4) Color varchar(10) Ideally I would like to group by the SalesmanID and receive a count of each of the fields described above. The best I could do is this: var
Read More...