jcrawf02 (3/25/2011)

---

Stefan Krzywicki (3/25/2011)

---

GSquared (3/25/2011)

---

jcrawf02 (3/25/2011)

---

GSquared (3/25/2011)

---

So start a completely serious post with, "I had this...

Stefan Krzywicki (3/25/2011)

---

GSquared (3/25/2011)

---

Stefan Krzywicki (3/25/2011)

---

GSquared (3/25/2011)

---

[I'm a DM. Have been since the mid-70s when D&D first came out. I'm essentially infinitely evil. 🙂 Have to be,...

Honestly, for sequential code like this and other running totals problems, I avoid the quirky update and use CLR assemblies, or a Static or Fast Forward cursor. Those are...

Don't do the unions thing. It's a pain to modify/extend/maintain.

create table dbo.Combos (

Diag1 char(10) not null,

Diag2 char(10) not null,

primary key (Diag1, Diag2));

GO

insert into dbo.Combos... -- put the valid Diag...

GilaMonster (3/25/2011)

---

GSquared (3/25/2011)

---

GilaMonster (3/25/2011)

---

GSquared (3/25/2011)

---

I'm a DM. Have been since the mid-70s when D&D first came out. I'm essentially infinitely evil. 🙂 Have to be, for the...

You...

Stefan Krzywicki (3/25/2011)

---

GSquared (3/25/2011)

---

[I'm a DM. Have been since the mid-70s when D&D first came out. I'm essentially infinitely evil. 🙂 Have to be, for the entertainment...

Put the combos in a table, join the table to itself via that, you'll have a solid, extensible solution that can easily accommodate more combos if/when business rules change, without...

jcrawf02 (3/25/2011)

---

GSquared (3/25/2011)

---

So start a completely serious post with, "I had this idea for an April...

It's a relatively simple mathematical pattern, but more rules are needed to have a complete solution.

For example, what would you do with a group that has more entries than can...

The CTE version will work. My first instinct was a simple Inner Join between two iterations of the table.

Why? For this query, it's not doing anything useful that I can see.

Sounds like the sa password got changed. Change it back, or reset it and rework your application or whatever is using it.

You shouldn't have an application using sa anyway,...

Gianluca Sartori (3/25/2011)

---

Fal (3/25/2011)

---

I just popped along to the Guiness World Records website to see if we could lodge The Thread under a Longest Web Thread category or similar. ...

Why are you grouping at all? Group By is for controlling data break-down on aggregate functions.