Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Aggregate

Author  Topic 

rjhe22
Constraint Violating Yak Guru

283 Posts

Posted - 2014-05-13 : 07:23:00
i dont no if this is even the right place for this.
but can anyone help. im using Aggregate and i have my balance field summing while the rest of the fields are grouped but yet it still wont sum up the balance.

any one any ideas why

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2014-05-13 : 10:02:28
post your statement. This sounds fishy: "the rest of the fields are grouped". The GROUP BY clause should only have the columns that you want to aggregate by.


Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -