Not sure what happened, but the first script under the Sign Reversals section should look like this:
TRUNCATE TABLE #Trans
INSERT INTO #Trans (Amount, [Sign])
SELECT 100, '+' -- [Assigned ID is 10001]
UNION ALL SELECT -100, '+' -- [Assigned ID is 10002]
UNION ALL SELECT 200, '-' -- [Assigned ID is 10003]
UNION ALL SELECT -200, '-' -- [Assigned ID is 10004]
UNION ALL SELECT 300, '-' -- [Assigned ID is 10005]
UNION ALL SELECT -300, '+' -- [Assigned ID is 10006]
UNION ALL SELECT 400, '+' -- [Assigned ID is 10007]
UNION ALL SELECT -400, '-' -- [Assigned ID is 10008]
UNION ALL SELECT 800, '+' -- [Assigned ID is 10009]
UNION ALL SELECT -800, '-' -- [Assigned ID is 10010]
SELECT * FROM #Trans
SELECT SUM(CASE [Sign] WHEN '+' THEN Amount ELSE -Amount END) FROM #Trans
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St