CAST (CHD_MONTHLY_INT_RATE AS DECIMAL (12,6) ) /100000

The likely reason it took 78 seconds the first time is because it probably made TempDB larger... the default initial size of TempDB is woefully inadequate.  Our production box at...

Heh... thanks, James.  Yeah, I use it a lot, as well... there are a couple of methods that are a bit faster, but there's none simpler or easier to write. ...

Pretty sure thats not the way it works, Tomm.  If it's 14:00 in central and GMT is used to write the time, the time that will be written is 20:00...

Midan,

At the risk of sounding mean, you're starting to sound a bit like a broken record... answer Jame's question... ARE YOU USING SQL SERVER 2005 OR NOT?

Thanks, Pop... I'll see what I can do... bet lot's of other folks jump on this one, as well.  It's an interesting and classic problem...

Thanks, Steve Hare...

I'll see what I can hammer out but I'm also interested in what Steve Jones said about searching a "services list" for MSSQL%.  I just need to find...

Steve Jones,

I'm a bit ignorant here... how do you "run a query, the search for MSSQQL% in the services list ia a more accurate way"?  Where is that "services List"...

Heh... Oxygenated Hydro-Carbon intebation.... at least THAT can be done

Steve,

Would you post the "dos reg /query" code you're using to find the version?  Then I'll see what I can do...

Also, not sure what you were looking at, but even you second example took over a minute the first time I executed it.

Thilina,

The real key is that Oracle caters to ISAM programmers (I call it "RBAR" which is pronounced "ree-bar" and is a Modenism for "Row By Agonizing Row") and cursors and loops,...

As a previous post inferred... do you have cursors and/or WHILE loops?  That'll be the performance killer... you might want to post your code with a description of what it...

Sugesh,

Do you have any batch code that will actually do this?

They bought a monster machine... thought they should have some monster software that can actually use all of it   And, of course,...