Jeff Moden (10/24/2010)

---

For the simple task of sorting in the correct order, we'll use the "Hierarchical Path" method. To build it, we'll use a "Recursive CTE". Look that...

Thanks Mark and Paul for the suggestions.

The case I came up with is for a training session so I'm trying to illustrate a point. I understand how...

Lynn Pettis (5/23/2012)

---

Jeff Moden (5/23/2012)

---

dwain.c (5/23/2012)

---

As the dark horse candidate in the race, it appears Jeff Moden has pulled into the lead!

Are those results ordered as #1 mine, #2 ColdCoffee...

Jeff Moden (5/23/2012)

---

You're right. That's what I get for going from memory... they say that's the first to go.

Thanks for the math lesson!

Chrissy321 (5/23/2012)

---

Thank you all again. I had never used a tally table.

Please allow me to ask a question which will clearly demonstrate I am still trying to understand the solution.

What's...

Jeff Moden (5/23/2012)

---

BWAAA-HAAAA!!!! Careful now... Do you gents feel compelled to use "0" or "1" in the Tally Table? Did you add a Clustered Index to the Tally...

So let's begin the campaign!

Here's a test harness to compare ColdCoffee's submission vs. mine over roughly 65,000 rows. ColdCoffee will need to excuse me but I didn't have a...

Shoot man! Talk is cheap!

Saying and doing are two different things.

In this thread: http://www.sqlservercentral.com/Forums/Topic1303878-392-2.aspx#bm1304951 I dived right in...

ColdCoffee (5/23/2012)

---

Dwain, if you watch closely, those CROSS APPLYs are not on Tally...

Chrissy,

Yes you do need a Tally table, but I don't think you need that many CROSS APPLYs.

CREATE TABLE #Companies (Company varchar(1), StartDate datetime)

INSERT INTO #Companies

SELECT 'A',' 4/3/2009' UNION

SELECT 'B',' 3/31/2010'...

Lynn Pettis (5/23/2012)

---

I think that is because I modified the OPs original code. This is the function missing probably: dbo.Validate_2_DelimitedFields_id. Is the the split function the OP was...

Jeff Moden (5/23/2012)

---

dwain.c (5/22/2012)

---

If...

I was curious how a TVF would compare performance-wise to a SVF for this solution, so I built the following two functions cobbled together from examples provided. Sorry Lynn,...

GilaMonster (5/23/2012)

---

dwain.c (5/22/2012)

---

Stefan Krzywicki (5/22/2012)

---

Many should format it all at once,...

Lynn Pettis (5/23/2012)

---

Not sure if this will work, but here is a shot:

CREATE FUNCTION dbo.itvfn_UpdatedProcedureLocation

(

@Additional_Procedure as varchar(max),

@Additional_Procedure_Location as varchar(max)

)

RETURNS TABLE WITH SCHEMABINDING

AS RETURN (

SELECT STUFF((SELECT ',' +

...