| martino rivaplata 2002-08-14, 11:23 pm |
| Hello There,
I am writing a group by statement, but the rows seem not
to agrreagate.
the sql i have is the following:
select account, category, timeid, entity, sum(signeddata)
as signeddata, source, channel, func,organization, type
from dbo.fcst_sum
group by account, category, timeid, entity, signeddata,
source, channel, func,organization, type
order by account, category, timeid, entity, signeddata,
source, channel, func,organization, type
and the results of this query is attached in the excel
sheet with this post. It should give just one row with the
column "Signeddata" aggregated.
Any ideas why this group by is not working.
Thank you very much for your help.
martino
|