Given this data:
ITEM DESCRIPT STYLE
aaa Item aaa 1
bbb Item bbb 1
ccc Item ccc 2
ddd Item ddd 3
eee Item eee 2

A pre-VFP 8.0 SQL statement such as:
SELECT itemno, descript, styleid, count(item) AS count
GROUP BY styleid ;
ORDER BY styleid ;
INTO CURSOR xxx

You get the following result:
ITEM DESCRIPT STYLE COUNT
bbb Item bbb 1 2
eee Item eee 2 2
ddd Item ddd 3 1

But this won't work in MS SQL Server. It generates an error "Invalid Group By -- all select fields must be used in an aggregate function."

So if I wantto simulate the result of the above VFP SQL statement in MS SQL Server, how do I do that? What combination of SQL Statements or computed columns or whatever do I need??

Joel