calston (3/4/2009)

---

Jeff, this was like a God-sent article to me. It's fantastic. I do need to add a few more groupings, but without your article I would not have been...

Heh... yep... that's the way, ST. Just gotta remember that you need to add a WITH (INDEX(0)) (didn't...

Just a suggestion... a good number of us have not upgraded to Office 2007 and some of...

Mangal9i (3/4/2009)

---

Hahaha...

Jeff Thank for advice.

In some of those deleted posts, I also mentioned that my self has asked such questions 100times... yes 100 times, or may be more than that....

Heh... has anyone noticed than Mangal deleted all but one of his posts here? And, take a look at the following... he'll be an excellent poster because of the...

ramu4ind (2/25/2009)

---

Hi,

how to convert milliseconds into hours,minutes,seconds and milliseconds.

i have two dates from that i have taken milli seconds using datediff.now i want to display total hours,minutes,sec,millisec in that milli...

heh.BecauseAllMyVariablesAndColumnNamesAreMixedCaseAndItsBecomeAHabit. 😛

Heh... I shouldn't post so late at night... I forgot the bloody spaces. :hehe:

Actually, all of the answers given use a performance crushing technique that will kill a server with relatively few rows. It's called a "Triangular Join" and it can be...

Heh... WHY? Isn't that one good enough? 😉

WHERE (a ISNULL AND b ISNULL)

http://www.sqlservercentral.com/articles/cross+tab/65048/

briangillock (2/12/2009)

---

Should it take 17-20 seconds to return a simple count? Another, relatively simple query takes 2-4 hours to run. I realize that can be very much affected...

nwinningham (2/17/2009)

---

I have just spoken with the person who created this function. He said that he runs this report at night. So, since he runs this report at...

Hey there, Norbert... did you get this worked out or do you still need help?