here's my query:
notes: amounts are either positive or negative
the sum in the above query results in the wrong total, which i can't figure out. when i look at the raw data to validate the results it's not right. Can anyone help without actually seeing the data?
Thank you! :)
What do you mean by "wrong?" Can you help us reproduce using a test setup and a subset of the data? Like so:
answered Mar 02, 2010 at 12:56 AM
I FIGURED IT OUT AND WHAT A DUMMY MOVE ON MY PART!!!
I WAS COPYING AND PASTING THE RESULTS FROM SQL TO EXCEL AND THERFORE AND NOT COPYING THE ENTIRE RESULT SET!
AS A RESULT OF THIS STUPIDITY, THE TOTALS WERE OFF. THE RAW DATA SUMS MATCHED UP TO TOTALS FROM THE CASE STATEMENT.
NOTE TO ALL: DO NOT COPY RESULTS FROM SQL TO EXCEL...YOU MAY MISS DATA!!!
answered Mar 03, 2010 at 01:18 PM
Refer this to know how you can copy data from table to EXCEL using a query
answered Mar 04, 2010 at 03:22 AM