Heh... reminds me of Father's Day and Christmas... "rank ties". 😛

Heh... "It Depends". 😛

Michael and Luke... same there. Glad to see the "rumors" I heard are absolutely true. 2 weeks has nothing to do with how long it takes... it's more...

That's pretty much what I heard the "rumor" was. Thanks for the confirmation, Steve.

Rayven (1/15/2009)

---

We already implement a helpdesk system (a corner of it I have hijacked just so we can track the work coming in and who it is allocated to, but...

Lynn Pettis (1/15/2009)

---

Actually Jeff, I know your sore spot./quote]

Heh... which one? The one I've dedicated by avatar space to?

dmc (1/15/2009)

---

No problem Jeff... I like a good debate! Its what makes the job fun and makes you rethink your basis of how you handle solutions to issues in...

dmc (1/15/2009)

---

Haha... I agree that truely portable code is almost impossible to achieve. 🙂 But working in an environment with multiple systems we try to make our code...

dmc (1/15/2009)

---

True... it is slightly (very slightly) faster. And in billions of rows it could make a difference. But is it wroth compliance of standards and advantages of...

Never mind... not enough coffee... 😛

That's pretty much like what Seth has and both are pretty much the way I'd do it...

latingntlman (1/14/2009)

---

Thanks for the suggestion. I went with a different one though, creating a separate insert temp table w/an identity field and insert from it sequentially using this identity field....

dmc (1/15/2009)

---

I would also look at the COALESCE() function. This allows more than one arguement to be evaluated and is also the ansi standard. But isnull also...

Ramesh (1/15/2009)

---

Since you are using SQL 2005, you have the windowed functions and the OVER clause....

Here is that query

SELECT *

FROM (

...

GilaMonster (1/15/2009)

---

Jeff Moden (1/15/2009)

---

I've been fortunate, recently... I've convinced folks to mostly NOT buy 3rd party software and, when we do, I get to grill both the software and the...