Viewing 3 posts - 1 through 3 (of 3 total)
That's it!!! Thank's a lot!!!
December 9, 2010 at 10:29 am
#1260668
Hi!!! I really sorry... I forget one thing... The quantities includes returns and the returns quantities are stored as positive numbers like this:
TrxId ItemId Date ...
December 9, 2010 at 9:15 am
#1260619
Wow Mark!!! Thank's a lot!!!
Didn't know that can use a CASE inside a SUM().
It runs very fast! Over 5million rows in less 8sec!!!
December 9, 2010 at 9:07 am
#1260611