shalinder.verma (4/3/2013)

---

Phil Parkin (4/3/2013)

---

shalinder.verma (4/3/2013)

---

I agree with David. The title was misleading and I got upset before reading the article and got angry after reading the article, save 'holy moly...

P Jones (4/3/2013)

---

As another MERGE fan I'd use

WHEN NOT MATCHED BY SOURCE AND (t.ID = s.ID) THEN DELETE;

in the original merge statement.

But I've no complaints about the article...

KWymore (4/3/2013)

---

Thanks for the article Dwain. Luckily I only use merge statements for updates and inserts. We rarely do deletes based on our business needs but I will definitely keep...

DavidBridgeTechnology.com (4/3/2013)

---

I think the title is misleading and a little unfair to the wonderful work Microsoft did with Merge (Despite its being 6 years after Oracle - poor show MS).

This...

Koen Verbeeck (3/28/2013)

---

Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.

Because someone has to answer all those BI questions on this forum...

First I'd like to thank everybody that stopped by and left some kind feedback on the question.

Second, I'd like to apologize for not saying the above sooner but I've been...

I'll refer...

Danny, Ron and Tom - Thanks to all for giving it a go.

The history of this was that I was playing around with passing subqueries to TVFs, hoping for a...

L' Eomot Inversé (3/24/2013)

---

Nice question.

But does the fourth batch fail with an error or with two errors? Anyone, I find it surprising that the two error messages give the...

L' Eomot Inversé (3/21/2013)

---

dwain.c (3/20/2013)

---

Lynn Pettis (3/20/2013)

---

I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing code and...

Lynn Pettis (3/20/2013)

---

I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing code and expect a free forum...

Test data?

Here's my shot at this:

;

WITH Tally (n) AS (

SELECT TOP (SELECT MAX(Number) FROM #TransDetail)

ROW_NUMBER() OVER (ORDER BY...

Retraction of solution posted.

Out of the game last night, so sorry I couldn't contribute more. But it appears MickyT and Steven Willis came to the rescue / problem solved.

I did say my...