First of all... very well written article. Nice to see examples like that with some performance stats. Unfortunately, the most important performance for the user (duration) wasn't measured...

You bet... thanks for the feedback.

Bob Hovious (3/11/2009)

---

Jeff, I understand about pre-aggregating, but why is it so important to do it with a temp table, rather than a derived table? Just so you...

Yep... right up until you dial a 1 or 3 digit country code instead of +44.

Country codes can be from 1 to 3...

Spikemarks (3/11/2009)

---

I have tweeked the code and have put it inside a cursor which should read the first 3 chars and then change to which ever it should be.

Once I...

Heh... close... the next question will likely be "How can I parameterize the TOPs in SQL Server 2000?"

Tony (3/11/2009)

---

Jeff - he is a beginner, this is his first job out of tech school, and we hired him because we saw his potential for learning. I never...

sumit-saini (2/16/2009)

---

Hi Jeff,

Thanks for the code, but i will be test the code tommorrow @ my work and i will be able to tell you the performance of this logic...

Sorry for the late reply. My answer would be "Nope... I'll use a temp table"... just wanted folks to know that it could actually be done.

KT8177 (3/11/2009)

---

I just wanted to updated everyone and say that we have found the issue. It was a memory issue, the server had AWE enabled but it...

Heh... nope... see above where I posted...

SELECT ID

FROM #Test

WHERE Countries IN ('IN','AU')

GROUP BY ID

HAVING COUNT(*) = 2

Heh... thanks for posting your solution. I guess that's why I don't like DTS or SSIS... T-SQL makes it so much simpler...

DECLARE @SomeDate VARCHAR(8)

SET @SomeDate...

That was the first question... now, let's see if the final question about this comes up. 😉

Did that answer your questions, Karthik?

scorpio_zz19 (3/11/2009)

---

i'm working with a payroll system wherin the time in and time out will be input basis coz that was the requirement, so how can i compute the total...