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? 

Maybe I'm just missing it... what does the output you listed have to do with the query you listed?

The problem with such "real time" apps is that no one plans on the connection being down Have your "trigger" write to a...

Kind of a double post... please see my other reply.

Don't embed the quotes... put the quotes around each full path.

Oh no, no, no... MJV had it right and ISNUMERIC does NOT mean ISALLDIGITS!

create table #tmp( tc VARCHAR(10))

insert into #tmp

select '0d01' union all

select '0e01' union all

select...