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,...

Robert brought up some very good points and I just wanted to expound on them.  There are two keys to good performance... one, of course, is the code folks write......

Pop, I agree with Serqiy... I don't think you need to break the source information into "by the minute" rows.  If you could post some T/A rows for a couple of...

Thanks, Aders, Steve, and Michael!

Sohil...

You do realize that UTC is based on the time at the Prime Meridian and that you need to subtract some hours from that to get Eastern Time, right?