Jeff Moden (3/18/2008)

---

In other words, Dragon3486... messy code is hard to troubleshoot. 95% of all such simple syntactical problems can easily be avoided altogether if you format your code...

The WITH ENCRYPTION is a misnomer anyway - since you're giving the system an automated way to decrypt the data. The "door being opened" is so wide that the...

Well - if you want a "master" of all MRN's out of both tables, I'd assume you want any mrn's in either table, and not just the ones that exist...

yup....What they both said....

It's amazing how much clearer it gets when you actually format your query.

SELECT

person.[person_last_name],

person.[person_first_name],

person.[person_middle_initial],

ordr.fy,

ordr.ordr_effective_date,

ordr.ordr_termination_date,

Max(person_pay.service_or_component_code) AS MaxOfservice_or_component_code,

person_pay.state_territory_code,

at_reimbursement.at_start_date,

at_reimbursement.at_stop_date,

asn.accounting_station_number

FROM

[LIVE].[dbo].at_reimbursement as at_reimbursement

...

Even if they didn't have permission before attaching the file - once the sysadmin attaches the database, they can change the owner to be whoever they wish.

So - the only...

I'd have to agree. Just about the only thing preventing NOLOCK would be a schema-lock, or something changing your DDL. Do you have something routinely modifying your table...

You need a table with the values you want to show as the "base table". LEFT OUTER JOIN from it onto the existing query you have and use its...

Can't say I see why it's not working in SQL server. That being said - your WHERE clause is unnecessary, since it's your ON clause as well.

GilaMonster (3/18/2008)

---

Matt Miller (3/18/2008)

---

GilaMonster (3/17/2008)

---

Yup. And...

Unless you're talking indexed...

The EXISTS clause doesn't care about the column return - it just cares whether there is a record found or not. In the case you wrote - the NOT...

hmm... Covering indexes unfortunately can fall into the "law of diminishing returns". Meaning - you're going to end up hitting the size limit sooner or later. Also -...

GilaMonster (3/17/2008)

---

Yup. And that, along with...

Adam Haines (3/18/2008)

---

Another solution, very similar to Matt's except this one filter to only get the records that have a gross or net = G or N.

SELECT TransactionID,

...