Million thanks, Jeff. I look forward to trying it out your sql solution.

As I'm sure you've heard from many others before, your thoroughness of tackling a problem is really something...

Jeff Moden (5/9/2011)

---

peterzeke (5/6/2011)

---

I'm trying to figure out how to concatenate the first letter of each word within a given string. It's bit like parsing a delimited list, I'd imagine....

WayneS (5/9/2011)

I used to use an XML splitter all the time... that is, until Jeff showed me the light. There is a thread on here somewhere that discusses it, but...

Excellent citations!

Jeff, your "older" article about concantenation has the following comment regarding the final XML concantenation solution:

I normally warn against using correlated sub-queries, but the following just absolutely flies (no...

Jeff/Wayne:

Many thanks for your replies! Hearing from the two of you is an honor. I had pondered using SQL from Jeff's tally-based splitting functions, but couldn't figure out how to...

It appears I've found one solution which I should be able to put into a udf:

DECLARE @STRING VARCHAR(8000)

SET @STRING = 'COMMUNITY GENERAL HOSPITAL'

DECLARE @TEXTXML XML

SELECT @textXML = cast('<d>' +...

Mark-101232 (3/16/2011)

---

Also a minor change will give you the NULL for the latest end month

WITH CTE AS (

SELECT ProcessID, Month, Compliant,

ROW_NUMBER() OVER(PARTITION BY...

Mark,

Just before you provided the second query solution, I actually started reading up on gaps and islands --I just didn't get a chance to put something to the test. (At...

Marrrrrrk!

OK, I'm completely jazzed by the elegance of the query. Reminds me of the various techniques I've seen by Itzik Ben-Gan leveraging row_number() and other ranking functions.

So, was...

Mark - your query solution is great. I was leaning towards a cte and row_number(), but your technique with correlating a query using EXISTS provides the missing piece that eluded...

Gail Shaw (aka GilaMonster) wrote a very nice three part series of...

Thank you for the replies. I was concerned that the nonclustered indexes might merely create overhead without any expected querying benefit. Good to know that it can be ok to...

Good point. By including "differential" records, counts can...

The sample report that Jack & I shared merely achieves "the look"...

Growing up with parents who have masters degree in music has placed music as a core feature in my life. So, more often than not, I have a pair of...