While BrainDonor's (love that name) suggestion will work, I find the UNPIVOT syntax so unwieldy (especially on double and triple UNPIVOTs) that I like to steer people towards the CROSS...

First off, you should probably be using MERGE for this.

Second, in a high transaction database, using IF EXISTS followed by UPDATE/INSERT as you are doing is quite dangerous because some...

Using only the stone knives and bear skins available in SS2K, I think this will run without error on that ancient platform, and may produce something somewhat close to what...

Let me apologize for my original bone-headed post. Not only did I screw up the syntax (I blame my current cognitive overload), I failed to notice that you're using...

Evil Kraig F (7/24/2012)

---

Would it be possible to provide the schema, some sample data, and the expected results from that data? The first question was simple enough to extrapolate...

OK I see the DDL now, sorry I missed it earlier.

Sample data can be done with an INSERT like as follows:

INSERT INTO dbo.Table

SELECT 1,2,3,4 -- As many...

I know you're a busy guy Jeff, so you must've missed my rCTE solution to the Sweden redistricting...

gert.lindholm (7/23/2012)

---

Hi again Dwain

When i was yunger i also loathe my name.

But older i get i get used to it.

My middle name is Erik.

And i´m named by an old...

xmozart.ryan (7/23/2012)

---

dwain.c (7/23/2012)

---

Assuming you want one result set returned to your client, you should consider doing it something like this:

;WITH Tally (n) AS (

ROW_NUMBER() OVER (ORDER...

XMLSQLNinja (7/23/2012)

---

Just got back from vacation and wanted to address this one first...

I must be missing something but I don't see how that recursive CTE (as much as I...

GSquared (7/23/2012)

---

dwain.c (7/23/2012)

---

GSquared (7/19/2012)

---

Jeff Moden (7/17/2012)

---

First, apologies for not responding sooner. I've actually be working...

Gert - You're most welcome.

I have a brother named Gert, although he is loathe to use that name. He uses his middle name instead.

We seem to be overlooking the cardinality rule of comments:

"Comments in code are always out of date and hence inaccurate."

Could be this used to apply but does no more.

I like...

Assuming you want one result set returned to your client, you should consider doing it something like this:

;WITH Tally (n) AS (

ROW_NUMBER() OVER (ORDER BY (SELECT...

GSquared (7/19/2012)

---

Jeff Moden (7/17/2012)

---

First, apologies for not responding sooner. I've actually be working on a...