Oh learned plenty so far. My SQL learning is simply matched up...

I think I'm going to go hide in my corner now. I'll...

Or, for the [EDIT] eternally stuck in 2k mindset... [/EDIT], a bit more oldschool:

SELECT

t1.*

FROM

Table1 AS t1

LEFT JOIN

Table2 AS t2

...

smknox (10/15/2010)

---

Thanks so much! This solved my problem so I thought I'd post it:

ORDER BY

CASE WHEN @SortVar='name' AND @order = 'ASC' THEN s.LastName+s.FirstName END ASC,

CASE WHEN @SortVar='name' AND...

Constantly forgetting that if I want to know what the SERVER is going to do with an SSIS/DTS package, I have to schedule it, not run it from the design...

GilaMonster (10/15/2010)

---

mtillman-921105 (10/15/2010)

---

When your a contractor (or consultant), in the beggining you're a miracle sent in by the angels, but toward the end of your time they always want to...

This. This this this. I passed...

Rats. I had hoped the Sargable nature of your code vs. mine would have improved performance. Guess it would depend on the base data set though and how...

Well, far be it from me to turn down a damned...

GilaMonster (10/14/2010)

---

Craig Farrell (10/14/2010)

---

I've been carrying a really bad myth around with me for years and never got called on it because the conversation never came up before on that...

David Portas (10/14/2010)

---

I don't understand your claim that an index alone provides better performance than a uniqueness constraint. Can you back that up with an example? I'm pretty sure you'll...

A couple of code shops I've been in were nothing but hamburger code. We fixed it only when we heard screams of murder, we pushed out code as fast...

Paul White NZ (10/14/2010)

---

It is frequently possible to achieve the desired 'running total' results while breaking one or more QU 'rules', but I think it puts Jeff in an awkward...

Sorry Paul, that was a bit abrupt and you deserve better than that, your explainations are always concise and instructive.

I would agree in general that quirky update should not be...

Paul White NZ (10/13/2010)

---

Can't, or shouldn't? I did get the correct results here when I tested the code, with no...