Sue_H (9/14/2016)

In the old school habits for the database world, there would be no ON clause used at all. It was a matter of trying to figure out the joins...

How?

Phil Parkin (9/8/2016)

---

In my opinion, Drew's approach is more consistent than putting short ON clauses on one line and longer ON clauses on two (because 'longer' is a qualitative measure,...

That's the point I'm making - it's consistent, but no more...

drew.allen (9/7/2016)

---

I always put my ON clauses on a separate indented line, because I want to keep it consistent. I treat short and long JOIN clauses the same, if...

Brilliant - that's the one, thanks 🙂

OMG,...

I don't think we'll get very far by trying to demonstrate things "how they should be", particularly if we could be following accepted behaviour ourselves.

Rather, I feel it's better...

richlion2 (2/19/2016)

---

Yet another blog type article, why do people feel compelled to tell every possible story they have to tell? No toy women soldiers? So what? It's one of those...

Just do what you're doing Andy, you're doing a great job.

Eric M Russell (10/23/2015)

---

To determine active / inactive status, I'm not looking for a specific value; it's

contextual based on a range comparison.

-- return all currently active customers:

select * from...

angel-626714 (10/23/2015)

---

david.wright-948385 (10/23/2015)

---

You have two indicators for the same thing: the flag, and whether the date is null. So it's possible to have a non-null cancellation date with a flag...

You have two indicators for the same thing: the flag, and whether the date...

Eric M Russell (10/23/2015)

---

I've found a Date type is more useful for indicating active / inactive status. I want to know when, not just if, a row changed to inactive...

Denormalisation alert 🙂