Only because you find it easy, it doesn't necessarily is for all...

If you find it easy - good for you and keep it to your self. No need to brag.

I...

Thank you for your suggestions and prompt replies!

Sean:

Jason:

i.e. Order # 2...

Didn't know about the table-variable... 🙁

I saw that. And I knew there was a catch - but failed to draw the correct conclusion...

Nice Q and Good To Know...

GSquared (8/6/2012)

---

Mike Dougherty-384281 (7/14/2012)

---

Jeff Moden (7/13/2012)

---

Mike Dougherty-384281 (7/13/2012)

---

Ola L Martins-329921 (7/13/2012)

---

...hence I never delete a-n-y-t-h-i-n-g from the tables. I use a switch "bit_deleted" and a view to get the not-deleted...

Mike Dougherty-384281 (7/14/2012)

---

Jeff Moden (7/13/2012)

---

Mike Dougherty-384281 (7/13/2012)

---

consider...

david.wright-948385 (7/12/2012)

---

...hence I never delete a-n-y-t-h-i-n-g from the tables. I use a switch "bit_deleted" and a view to get the not-deleted...

This is a fundamental in my own life - discovered by struck of luck in my youth.

In school, all standing in a group around a subject, I made a remark...

The "Don't know" alternative should give you points, right? I mean, if you don't know, then the correct answer is actually "Don't know"... 😉

Hugo Kornelis (11/17/2011)

---

Ola L Martins-329921 (11/17/2011)

---

GPO (11/17/2011)

---

There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the...

GPO (11/17/2011)

---

There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the various symbols for GREATER THAN...

sknox (11/17/2011)

---

I've seen this crop up enough time on the forums to see why it rates 2 points.

While the answer is super-easy if you know DATETIME, this question highlights one...

It's a good question - I didn't know these new types!

But, the answers rule out themselves - you actually cannot get this one wrong with logical deduction:

If #3 is true...

Of course, failing the question I will argue that this question should be under the category (yet to be added) READING... 😉

Steve Jones - SSC Editor (11/15/2010)

---

I'm not sure why someone woud vote this down if they knew this technique. Are you saying that all articles about things "you" know shouldn't...

Maybe the low ratings is due to the fact that most programmers and db-developers "know" this solution already: The old "sort numbers stored as text as numbers"... ("1" ,"2"..."10", "11"...