Brandie Tarvin (7/6/2012)

---

OCTom (7/6/2012)

---

Brandie Tarvin (7/6/2012)

---

Someone please explain to me why donut shops insist on placing single donuts in the bag icing side down. I don't want my icing sticking...

Whew! That's a relief. Thought I'd missed an...

If you guys are going to...

peter-757102 (7/6/2012)

---

dwain.c (7/6/2012)

---

Jeff,

I just scanned all 35 pages of this discussion thread seeking the revised string splitter but unfortunately was unable to find it posted by you.

Can you point me...

dwain.c (7/5/2012)

---

I checked my NewDistricts table and these two aren't in it but they should be, so I need...

Jeff,

I just scanned all 35 pages of this discussion thread seeking the revised string splitter but unfortunately was unable to find it posted by you.

Can you point me to the...

Using Jeff Moden's string splitter: http://www.sqlservercentral.com/articles/Tally+Table/72993/, you can do it like this:

DECLARE @str VARCHAR(20) = '1^2~3^4~5^6'

SELECT Col1=MAX(CASE WHEN t.ItemNumber = 1 THEN t.Item END)

,Col2=MAX(CASE WHEN t.ItemNumber...

I checked my NewDistricts table and these two aren't in it but they should be, so I need to...

Les Cardwell (7/5/2012)

---

I haven't walked through the code yet, but...

[33,51,60] - is a triple

[55, 66] - is a double

Triples - I only count 9 in your list. Add the above...

sqlfriends (7/5/2012)

---

I just tried it, when I paste to excel, it still has the appostrope, like '9-12

It is not hiding the ', also tried to paste special as text, same...

Two surrounding apostrophes to denote the character string. Because apostrophe is the character string definition operator, you...

Gianluca - Thanks for the positive comments and I hope the effort may be useful some day!

In reviewing my own work, I found a few corrections that should be considered:

Errata

--------

1. The reported PopulationMean for the Uniform Distribution is shown as 4. The correct value of...

Without a better idea of what such "futuristic" errors may be, I'm not sure I can help you.

I will point out that data cleansing should be addressed by the front...

vijay.s (7/5/2012)

---

Yes Distinct Can Work but If we modify our query for finding dynamic level then same will fail.

;WITH MyModules AS (

SELECT m.ModuleID, Caption, SourceName, 0...