If I had to guess - the person who wrote this started out writing queries in Access. It prefers to nest joins inside other joins, e.g.

select column

from A

...

Sorry to give the generic answer, but - "it depends". In my mind - this mostly depends on how your organization accesses the DB resources and modifies data. ...

mine's a blame avoidance system with proof, but yep -...

Jeff Moden (5/11/2015)

---

Gary Varga (5/11/2015)

---

Jeff Moden (5/10/2015)

---

I think a lot of people get "auditing" mixed up with "logging". In the former, it must not fail because there are legal...

It's actually "working as designed". The behavior has to do with sub-queries, in that the subquery has access to the data from both the tables named in the subquery...

Are you expecting that the rowID's be consistent based on the physical order within the given file? Unfortunately you would need to set up the ordering mechanism to KEEP...

Steve Jones - SSC Editor (5/5/2015)

---

Eric M Russell (5/5/2015)

---

In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the...

only word of caution would be to check where the BEGIN TRAN is. I've seen a few doozies where the "rollback" is in a child/subprocedure and is intended to...

You can also prevent folks from "jumping out" of the app.

There are a few tricks which could make it tough for someone to get to the linked tables,...

Steve Jones - SSC Editor (4/24/2015)

---

I'd crosstab it more like this:

SELECT customers.name,

SUM( case when year(date) = 2014 then unitprice*qt else 0 end) AS total_2014,

SUM( case when...

Brandie Tarvin (4/24/2015)

---

GilaMonster (4/24/2015)

---

Also watch out for the sun. You can get sun burn far easier at high altitudes than low. Take sun cream, use it liberally, even if the...

Clearly - using the cascade on the person table will not be what you want (delete would take out the person itself). If the separate table isn't workable either,...

or HL7 (the old-style ones that is).

You have a bit of a normalization issue, which is complicating your issue. As DJJ pointed out, as of now with the structure in place you have to maually...

Just guessing, but could...