This might be a simple one, but I can't seem to figure it out. 500 pts. because I need it right away.
I have a query that has 2 records per ID in it. One for the run month and one for the prior month.
AsOf ID Shift
30-Jun-06 9113 -2.23096039
31-Jul-06 9113 0.278805355
30-Jun-06 9103 2.8866533
31-Jul-06 9103 1.297256548
What I want is the opposite of sum for each ID.
Any help would be greatly appreciated.