Thanks, SW...

Peter is correct, though... if all of the values for a given account number are <= 0, the account won't print (dunno if you want that or not).  Peter's...

Sam,

You took a good first step by defragging the DB.  Now, about that "slow query" and "insufficient memory" problem... "slow" normally means "resource hog" for CPU, IO, and Memory.  If...

I believe the training kit will give you a good idea... wait for the training kit before you book the exam...

This should do it...

--===== Setup a table to test with

 CREATE TABLE #MyHead (AcctNo VARCHAR(10), Month1 INT, Month2 INT, Month3 INT)

 INSERT INTO #MyHead (AcctNo, Month1, Month2, Month3)

 SELECT 'A',  -1,  ...

Since you're trying to print a PDF file, is Acrobat Reader or a print driver for PDF's installed on the server?

The service pack notation revers to Windows.... you have SP4 (8.00.2039) on SQL Server.

There is no bug that does this... it's a setting.  SQL Server 2005 is setup for CONCATENATE...

The answer is because you are doing the rounding first and then taking the sum.

By the way... the first letter of SQL stands for "Structured"... you might want to apply...

And what would you like to display if all 3 amounts are <= 0 ?

Why can't you or don't you want to use SET ROWCOUNT @MaxRows???

Ummmm.... I gotta know.... WHY are you trying to do this in a script?

Heh... at least it sounds the same... I've been called worse

Another place to look is under "Expanding Hierarchies" in Books OnLine...

Sure there is... is Table "A" the only table you need to draw from?  Also, can you type up an example of what you'd like the output to look like?

You said there was a correlation between a long running query and the slow down... fix the QUERY.  Long running queries are usually IO and CPU hogs.  Fix it before...

Sounds a lot like homework... What have you tried?