>>>>>>>>>>>>>>>>>>>>>>>>>>>
I'm trying to install some SQL disipline in this place. Is there a SQL statement to return me counts, sums etc by a unique value, say location code for a result set of a query?
>>>>>>>>>>>>>>>>>>>>>>>>>>>

How about:

Select Count(*), Sum(nValue) from MyTable ;
Group By LocationCode