If your trailing digits are always 3 or 4 in length, you could do something like this which avoids to overhead of either PARSENAME or REVERSE.

with Something as

(

select '000006-00005-254-008' as...

bpowers (10/25/2013)

---

We are populating a new database (Company2) with the vendor data that is currently in the Company1 database, using the wildcard to pickup all the fields. However, there is...

asdf-146317 (10/28/2013)

---

Usually merge is modifying a tiny portion of the target rows. I do not think your test case is a valid real-world example since it would only happen...

Just in case you or anyone are having this issue,...

Mark - Thanks for the highly relevant thread. Paul's analysis is clearly informative, as his analyses usually are.

I'm surprised...

andrew.fenna (10/28/2013)

---

This can be wrote as:-

-- MERGE

MERGE #Target t

USING (@ID, @Value

) s (ID, Value)

ON s.ID = t.ID

...

twin.devil (10/28/2013)

---

dwain.c (10/27/2013)

---

guy.stephens (10/27/2013)

---

Much as we love the Merge statement in my workplace, we seem to be running into deadlocking problems that we haven't had when using the UPDATE/INSERT .....

Hey Phil! Good to hear from you and thanks for the compliment.

Haven't seen you out and...

rmechaber (10/28/2013)

---

Thanks Dwain.c.

No, I don't see the behavior being at odds with BOL either, but I do see it being at odds with computational integrity and statistics. And BOL...

Pretty much any rCTE can be written as a set-based WHILE loop and often the performance of the loop will beat the rCTE.

While not a node traversal, this article has...

guy.stephens (10/27/2013)

---

Much as we love the Merge statement in my workplace, we seem to be running into deadlocking problems that we haven't had when using the UPDATE/INSERT .. LEFT JOIN...

kbenton 6603 (10/27/2013)

---

Thank you for your replies. I will post a query tomorrow in make table format for all to see. And yes the rows can be anywhere...

Not exactly a newbie question I'd venture to say. Some of those graphs examples are pretty deep stuff.

Beware of the recursive CTEs that he's using. They may produce...

Retracted due to lack of coffee.

SET @body = @Bill + ', ' + CONVERT(VARCHAR(10), DATEADD(day, 5, GETDATE()), 110);

Use whatever CONVERT format code floats your boat (I chose 110).