Thanks for the reply but I couldn't run it in 2005 either... I tried the new one you sent and it works like a charm...

Anyways to answer the last part...

When you create your table you can actually give it the name you wish... i.e.

CREATE TABLE #bogus (S_MONTH datetime, S_SUM int);

I tried your suggestion just for learning and I'm getting errors running it both in 2000 and 2005. Here are my errors:

Msg 156, Level 15, State 1, Line 1

Incorrect...