I...

I found this in BOL under DATEPART

DECLARE @date DATETIME

SET @date = '12/15/1997 11:59:00 PM'

SELECT DATENAME(dw,@date),DATEPART(hh,@date)

This will fix it.

...

sognibene, no clue about 2005.

Barry, just so you know...I'm sucking my thumb right now. Thanks so much for lending us your time an superior expertise, I have so much...

Barry

One more thing you might want to consider, is the scenario that broke my loop situation. Is there ever going to be an instance where for a given date,...

sognibene

I know there is a better, set based solution, but my yellow belt SQL skills preclude me from grasping it. With that being said, I have a loop solution...

sognibene,

I have been working on this to no avail. There were times when the correct result was right on the tip of my tongue, but I could not catch...

DOH!...I didn't even think that was what the OP actually wanted.

milzs, have you tried?

SELECT

*

FROM sysobjects

WHERE id = 1655012977

Here is one method that I use, mentioned by Garadin. It seems to be working for my situation, but you should try to "break" it. Maybe I have...

FreeHansje (10/16/2008)

---

Now, I could find a server, where I can start a trace, execute the change on EM and lookup the statements in the trace and use them in my...

Can you import the file into a table, then update it there?

Karthik, check this out, I think it will work for you if you modify it a bit.

http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/

Sorry Karthik, variable column names would be way over my head.

Karthik

This is just my opinion, but it seems like the measurements are more stable than the managers. Wouldn't it be better to have the measurements as columns and managers...