This looks strangely familiar to a product I ran across some years back. Unfortunately I can't remember the name of it. Too long ago or I'm getting old...

You need a little help getting help. 🙂

Below is a consumable version of your source data:

;WITH a ([Record Number], [Status], [Column Name], [Date Started], DateCompleted) AS (

...

This resolves the simple case you've given us, however I suspect it may not be the solution to your problem.

;WITH CTE AS (

SELECT AgentNum

...

SQL Kiwi (11/30/2012)

---

dwain.c (11/30/2012)

---

Looks like I've got a bit of reading and exploring to do now. Looks like a heck of a library. Gonna keep me away from...

SQL Kiwi (11/29/2012)

---

I...

Paul - Thanks for stopping by and making the CLR suggestion. Haven't seen you posting much of late so seeing your name pop up surprised me.

I'm a bit CLR-challenged...

mickyT (11/29/2012)

---

dwain.c (11/29/2012)

---

To all who participated in this thread:

You may wish to review this new article:

http://www.sqlservercentral.com/articles/String+Manipulation/94365/

It provides a good utility function for solving this case and many other similar ones....

Post deleted - SSC hung and posted this one to the wrong thread.

Hi Phil - allow me to propose something for you.

DECLARE @RowCount INT

DECLARE @IDs TABLE

(InvoiceId int not null

,BookingId int not null)

INSERT INTO...

mickyT (11/29/2012)

---

dwain.c (11/29/2012)

---

To all who participated in this thread:

You may wish to review this new article:

http://www.sqlservercentral.com/articles/String+Manipulation/94365/

It provides a good utility function for solving this case and many other similar ones....

To all who participated in this thread:

You may wish to review this new article:

http://www.sqlservercentral.com/articles/String+Manipulation/94365/

It provides a good utility function for solving this case and many other similar ones. Thanks...

So how about an example?

I'd...

Alan.B (11/29/2012)

---

Great, great article Dwain. Amazing work and perhaps your best article yet on SSC IMHO (it's certainly your longest).

I would have been delighted to propose a looping solution...

And finally a reply to all that have replied on this discussion thread.

My thanks to all of you for your comments and taking the time to read the article. ...

Jeff Moden (11/29/2012)

---

Nicely done, Dwain! I've not done a deep dive on it all but it's a great read that you really did put your heart into. Due...