You can use something like the below to indicate a total failure somewhere. At least in the testing phase.

	DELETE
	FROM dbo.star_wars_film
	WHERE film_id IN (
			SELECT film_id
			FROM dbo.purge_test
			WHERE purge_type...

As a near-senior citizen, I’d like to know how one goes about protecting and remembering 30 or 40 different accounts/passwords. Password vaults are only as secure as the password...

I will still continue asking stupid questions about queries until I feel fit enough, after all I’m a junior BI Developer now

And that is the very reason Steve's approach...

• This reply was modified 5 years, 5 months ago by  david.wright-948385.

Some great points, Steve, but please don't go down the sensationalist/quasi-abusive route to spark debate.

Wow.

Nice one David.

These issues come up time and again: the need for an environment that support honesty, while still maintaining accountability. The need to identify and learn from...

One of my devs had exactly this problem a few weeks back. My advice was:
* always alias tables
* always prefix column name references with the table alias
* it's...

If you don't already enjoy your work, find a way to enjoy it. Whatever you're employed to do, you'll be better at your job; you, your colleagues and your employers...

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