I changed the order by and it returned 12 records for the 1st month. I'm expecting 5 records for each month. Thank you.

SELECT DISTINCT t.Company,sales.[Month], sales.Sales
FROM TestTable...

I reinstalled it to resolve.

Thank you!

Do you mean change the select to print? I want to be able to copy the results in grid view and paste it in a new query window to be...

Thank you. This works.

When I run the query in sql server management studio I need it to return 3 columns (type1, type2, type3) with 3 records each.

column type1 has the following 3...

😎

Thank you 😀

I need the month spelled out like January.

I tried it this way and got Jan 1, 2011.

SELECT CONVERT(VARCHAR(50),mt.hiredate,107) FROM MyTable mt