Well on the devil's advocate side of the argument - if you don't know why your patch might fail, it's going to be difficult to guarantee a way to back...

pdanes (4/18/2013)

---

GilaMonster (4/18/2013)

---

Eric M Russell (4/18/2013)

---

Also, tell the candidate up front that all new hires are required to sign an "employment at-will" contract. If they don't measure up, then they'll...

You're going to want to use FOR XML PATH instead of AUTO. Assuming you do, the query would look something like:

select Mortgage.AccountNo

, (select

( select Customer.CustomerNo

from #MortCustLink...

Sorry - was running a bit short on time last night - update the spelling of ENCOUNTER in this line (the second one - where the underscores are):

cross apply Changeset.nodes('/root/ENCOUNTER.ENCOU___TERSTATUSDESCRIPTION')

You...

The short answer is "spelling counts". Your query is misspelling the node name you want. (i.e. couNter)

Sergiy (3/19/2013)

---

try to run

SELECT

BatchID,

FieldA,

FieldB,

CAST(ISNULL(ROW_NUMBER() OVER (PARTITION BY BatchID ORDER BY DateEntered), 0) AS...

Jeff Moden (3/8/2013)

---

Matt Miller (#4) (3/8/2013)

---

Jeff Moden (3/7/2013)

---

Revenant (3/4/2013)

---

Evil Kraig F (3/4/2013)

---

Revenant (3/4/2013)

---

I always find it frustrating when someone asks me or someone else to do things for which T-SQL...

Jeff Moden (3/7/2013)

---

Revenant (3/4/2013)

---

Evil Kraig F (3/4/2013)

---

Revenant (3/4/2013)

---

I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this...

Besides - all of those sorts methods you mentioned presume a flat list structure. The internals for how tables are structured are anything but flat.

In short - I suspect...

One of the issues you need to account for is that you can't assume that a single row is being inserted. The trigger fires once per insert operation, not...

Not sure if this is purely for the purposes of the example, but your query essentially sets...

Just about any UML tool can help you create logical models.

Each of the tiers needs to be based on the table contents in some way, since they might have attributes filled in.

Try adjust to something like:

;with

t1 as...

Lynn Pettis (12/11/2012)

---

Going out on a limb here, but I think it is because the connection is broken (or not established) even though it is not severity 20 or higher:

Errors...

I would tend to agree with Lynn. The connection is considered closed, so the error is lost.

Assuming that's true - you'd probably catch it if you wrap within a...