Never underestimate the capabilities of a clever but bored engineer.

Is the "@Test1=NULL" in the middle of the case statement correct? Shouldn't that just...

What about converting a given column to a sparse column?

5 - NEVER EVER EVER use SSMS's 'Edit Top 200 Rows' feature. "Using this locks the table when the window is left open".

I've all but proven this one untrue,...

Not sure what the purpose is for the "SET IMPLICIT_TRANSACTIONS OFF" at the end of the script.

If we ever work together we may never finish anything since we will just keep changing * to 1 and 1 to *. I am reminded of the Sneetches story...

Eirikur Eiriksson (1/10/2015)

---

Jeff Moden (1/10/2015)

---

Requires prior knowledge that the "T" is the exception. I realize that's exactly what the OP asked for but was that just because of the...

That's not quite right. ...

+1, but I'll take the...

You might have better luck doing the grouping is SQL.

What is the reporting or presentation tool that is replacing Excel? Something like Crystal or SSRS?

Incidentally, I have a similar problem with CountDistinct. For a particular report, where there are 15 groups, this function:

RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)

skips 2 when the set is ordered alpha...

gissah (1/13/2015)

---

I am trying to count just the rows on group1 level without using CountDistinct in ssrs 2008 without counting the detail rows.

CountRows("group1") or count(group1) all gives me the detail...

It's interesting that neither of these:

substring('aeiouy', cast(rand() * 6 + 1 as int), 1)

substring('aeiouy', cast(ceiling(rand() * 6) as int), 1)

exhibit the same problem.

Koen Verbeeck (1/7/2015)

---

DonlSimpson (1/7/2015)

---

1 + 2 + 3 + NULL is NULL, absolutely. NULL is not replaceable by zero. Any set with a null value has a null...