This also works, using the PatternSplitCM FUNCTION that Chris Morris contributed to the 4th article in my signature links.

with Employee as

(

select 'ABC' as Surname, 'x.yz' as...

Luis Cazares (3/12/2014)

---

I might be trying to kill a fly with a cannon but this could be an option. It could be turned into an inLine Table-valued Function if needed...

Sean Lange (3/12/2014)

---

shan-422658 (3/12/2014)

---

Thanks for your reply.

Just a version 2 of the above query…

Surname GivenName

ABC x.yz

ABcx.y.z

ABC X.*YZ

A*.BC xyz

The...

This takes 34 seconds to run against 3.5M account moves.

CREATE TABLE #accounts (accountId VARCHAR(10))

CREATE TABLE #accountMovs (accountId VARCHAR(10), debit INT, credit INT)

GO

INSERT INTO #accounts VALUES ('11')

INSERT INTO #accounts VALUES ('111')

INSERT...

Perhaps this is not quite so ugly:

SELECT Style, GroupedAmendmentIDs

FROM

(

SELECT Style

,GroupedAmendmentIDs=STUFF((

...

Greg Edwards-268690 (3/12/2014)

---

dwain.c (3/12/2014)

---

Luis Cazares (3/12/2014)

---

In another order of ideas, today I had a good experience to prove your quote about indexing and cat food. A process with an insert...

Luis Cazares (3/12/2014)

---

In another order of ideas, today I had a good experience to prove your quote about indexing and cat food. A process with an insert and update to...

I'll second what Sean has said, but I wanted to add something.

It is good that you have recognized that the problem is the loops and cursors. And that a...

Luis Cazares (3/12/2014)

---

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already...

Did you try my solution...

That's known by the fact that the table name appears 3 times...

Jeff Moden (3/11/2014)

---

Greg Edwards-268690 (3/10/2014)

---

Luis Cazares (3/10/2014)

---

Lynn Pettis (3/10/2014)

---

If any one has some free time this person could use some help. I don't have the free time at the...

You're welcome.

Note to any of the other masters that take a look at this. The OP wanted a mixture of integers and dates in his output. I cannot...

Are we getting close yet?

WITH Dates AS

(

SELECT d=CONVERT(CHAR(10), @FromDate + n, 120)

FROM

(

...

You could do it that way but it might be faster to do it with one table scan instead of three:

SELECT StepName

FROM testdata

GROUP BY StepName

HAVING COUNT(CASE WHEN StepStatus = 'Starting'...