Eugene Elutin (11/13/2012)

---

edward_hall76 (11/13/2012)

---

ok. where I work not all people know how to write tsql code and if they mess up the tsql they do not know how to fix...

This is a cursor-based "RBAR" function so if this is going to be a task that runs often it may be necessary to rewrite it using a Tally Table for...

Just guessing a bit here since I don't know what data is in those 100 columns...

But wouldn't it make more sense to have a set of normalized tables with...

The DelimitedSplit8k option has been shown to be among the most efficient methods for splitting strings. Another less-complicated but les efficient option is below. Whatever method you choose, I'd recommend...

If anyone still cares...

I used Jeff's test data (#PostalArea and #CsvTest) and did the split (output = 1,000,000 rows) using the DelimitedSplit8K function and an XML splitter function. The XML...

I can't give specifics since you gave none. However, if I'm reading your post correctly, the problem you have is running multiple stored procedures, saving the results somewhere, and then...

Here's how to make your query using Jeff Moden's splitter function (of which a slightly modified version is shown below):

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

DROP TABLE #TempTable

CREATE TABLE #TempTable (

...

opc.three (10/23/2012)

---

Steven Willis (10/23/2012)

---

opc.three (10/22/2012)

---

And that platform would be...care to...

DotNetNuke

DotNetNuke Users List

...and...

matak (10/17/2012)

---

Hi,

Ive finally been allowed to redesign some tables which are "wide" (Think Field1, Field2, Field3 ... Fieldn). There are multiple fields that do this and columns get added when...

Timothy Graffham (9/19/2012)

---

I was very excited to go to my post this morning and see 8 responses. I thought I was going to get some real help. Instead,...

DECLARE

@s-2 VARCHAR(MAX)

,@Split1 CHAR(1)

,@Split2 CHAR(1)

,@Split3 CHAR(1)

,@X XML

/* User input */

SELECT

...

Jeff seems to have beat me to it, but here's a similar XML parsing procedure I've used extensively.

CREATE PROCEDURE dbo.ParseXML

@strXML AS XML

...

Then you are probably stuck with using a CTE. Perhaps you can compare the code I offered with the CTE example above to see how you can do a recursive...

Here's a stored procedure that you can use to parse XML. The first example inside the procedure is the XML posted by the original OP. I've included a more comprehensive...