Yup. If only politicians could adopt the same approach.

MMartin1 (9/15/2016)

---

I find it clearer if AS is used consistently when aliasing anywhere. If I can...

Please note I'm looking at the layout, not the detail. Here's a suggestion:

USE TESTDB

GO

DECLARE @checkDate DATE = DATEADD(day, DATEDIFF(day, 1, GETDATE()), 0);

SELECT[Work Type]= d.WORK_TYPE,

[Date Opened]= CONVERT(varchar, a.ACT_DATE, 103),

[Time Opened]=...

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...