Thanks for the feedback, NorVid.

That would be Hawaii...

In the same vein, which state observes both Central Daylight Time AND Eastern Daylight Time?

Can you post what you used?  We can all learn a new trick or two....

Me, too... let us know what they say, Luk?

sp_lock

sp_who2

Find wherever sysinfo.exe is on the C: drive and execute it from a cmd window... more information will appear than you could possibly use including the number, make, model, revision,...

I'd likely make it use a few more CASE statements to keep from having to dip the Status table 3 times in the FROM clause... crosstab code is VERY fast if...

Heh... going back to the other posts, I see that now...

Hope things are going well for Mother and Child.

Can you post a line of the troublesome data?

Will a cursor fix it?

That does it!  I'm moving to Arizona...

I don't have your data so not sure what else is going on... the following returns 1.3 as expected... (SQL Server Developer Edition and Enterprise Edition, sp4)

DECLARE @test-2 DECIMAL(18,4)

SET @test-2...

Because, first, you must have an envelope   Lot's of folks just aren't gonna make it to 2005 because of budget and manpower. ...

Heh... that coming from a person that lives on an island

Yes... it does work... if you actually know something about SQL    And, the responses normally go directly to the person providing the opportunity...