Do you always want to round up? Or why isn't the first result 1.25?

You're welcome, feel free to ask any questions that you have.

I also created an initial version that lacked versatility and replaced only the first order number. It was like this:...

Then just follow the process described in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

WITH cteOrders AS(

SELECT DISTINCT OrderID

FROM #Status

)

SELECT OrderID,

STUFF((SELECT ',' + Status

...

Are you missing information? Where do you get the persons that will be assigned? Are those the reviewers?

Why are you doing that? It will only make your querying more painful. You shouldn't store comma-delimited values in the db.

Here's a possible option. Be sure to test what it does and understand it.

It basically splits the strings to find the different digit portions by using the PatternSplitCM which can...

As you might have noticed, BEGIN and END won't define the begin and end of a stored procedure.

A stored procedure must be the only statement in the batch, so anything...

A slightly different version of Eirikur's code. This is just to give you more ideas on the different possibilities to solve your problem.

DECLARE @sourcedata TABLE(STR_DATA VARCHAR(100) NOT NULL);

INSERT INTO @sourcedata(STR_DATA)

VALUES

...

Sean Lange (8/11/2015)

---

Luis Cazares (8/11/2015)

---

You can use a code like this:

WITH RowNums AS(

SELECT *, ROW_NUMBER() OVER(PARTITION BY account ORDER BY date DESC) rn

...

You can use a code like this:

WITH RowNums AS(

SELECT *, ROW_NUMBER() OVER(PARTITION BY account ORDER BY date DESC) rn

FROM SomeTable

)

SELECT *

FROM RowNums

WHERE...

Alvin Ramard (8/11/2015)

---

Ed Wagner (8/11/2015)

---

Sean Lange (8/11/2015)

---

Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a quote I don't think I've every...

Normally, Grant's remark should be on point, but here you need to change the column. I added a few other improvements that you might want to implement. Avoid 3 part...

If this doesn't give a full solution, it might give an idea.

with base as (

select

*,

rn = row_number() over (partition by left(kms_quoteorder,charindex('/',kms_quoteorder +...

This article explains the FOR XML PATH approach.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Is this the confetti you wanted?