But SQL grouping must be accompanied by aggregation, and cannot retain grouped subsets for further processing; At this point, it is necessary to change the mindset, set various markers to transition, ...

I've tried all kinds of combinations of selecting the top 10 with a count query but can't seem to get the 10 records to be anything but the last 10 inserted. <BR><BR>Not being a strong SQL guy ...

produce a result set for the report that shows a side-by-side comparison of the number and total amounts of payments made in Mike's and Jon's stores broken down by months. The resulting data set ...