Ajit Goswami-482889 (1/23/2011)

---

Thanks Wayne and everyone else for your insights.

I just wanted to be sure that i am not the only one who has faced this issue. 🙂

I'll do my...

MM - very impressive solution. Very well done!

Out of curiosity... did you try the tablockx hint? (I don't think it would make a difference.)

Jeff Moden (1/22/2011)

---

Heh... nah... two reasons. 1) If I can make something run fast on my...

With your test data, on my 2yr old dual core Intel P-8600 @ 2.40GHz, 8GB RAM, Vista Ultimate 64-bit SP2, SQL 2008 64-bit SP2 (phew!):

(oh yeah... you really need to...

CirquedeSQLeil (1/21/2011)

---

Ajit Goswami-482889 (1/20/2011)

---

All your guesses are true but my issues is not mainly about the performance but the weird behavior that is being demonstrated by SQL.

I am using 3...

Ferguson (1/21/2011)

---

GSquared (1/21/2011)

---

Just to beat this dead horse a bit more:

I have heard two threads in this -- one is "but when will I have time to do both" and...

Ferguson (1/20/2011)

---

To me that's just normal practice -- but it appears to be a presumption here (at least by some) that with zero hints on salary that it was already...

How's this?

;

WITH CTE1 AS

(

-- get the row number with 1 being the most recent.

-- restart numbering at each Proc1/Proc2

SELECT Proc1, Proc2, [Status], MDate,

RN...

GilaMonster (1/21/2011)

---

Silly me. I thought specifying monday morning...

Ajit Goswami-482889 (1/20/2011)

---

I have a question now on how the Table Variable and Temporary table behaves because while executing a batch statements today i got an issue when i was...

surreydude. (1/20/2011)

---

One thing I did notice about the article, however, was the use of yy for year formats. It would seem that the "Y2K Bug" has not taught us very...

Justin,

You're welcome... and thank you for mentioning it. This will actually help a lot of people feel good about what they're doing here.

(When you need help, it helps us tremendously...

I'll second this advice. There...

Virtual celebration time.

Joe answered the question, no rants, no ISO standards speech, no drawing comparisons to punchcards... he just plain answered the question.

Now, who has that bubbly image so we...

This thread has made me realize that I suck in deciphering job descriptions. Craig, hurry up with your articles - I need the help!!!