I've done some extensive testing using a modified version of the test harness from Jeff Moden's Tally Oh! article to test the various split methods in this thread. My test...

Sean Lange (12/28/2012)

---

Did you read the whole article and look at the performance comparisons? This style of xml splitter was on the list and it was not...

Jeff Moden (12/21/2012)

---

Steven Willis (12/21/2012)

---

First test used the same data as generated in a post above using a Tally table CTE. I generated test data with 100 rows, 1,000 rows,...

[EDIT FOR CLARIFICATION: When using the DelimitedSplit8K function it makes no sense to use it on strings longer than 8K and it will not perform as well as other methods...

I know Jeff Moden's splitter function has already been discussed. But this is how I would do it with no aggregates or case statements:

DECLARE

@InputString VARCHAR(8000)

...

This is very long and convoluted but it works using the built-in SQL XML Schema Collection object and methods. I'm sure the experts will pick it apart--that's fine. If it...

OK, sorry. I only read the first few posts and made some faulty assumptions. After considering the last few comments I can see that it really is more complicated than...

Try this...

IF OBJECT_ID('TempDB..#mytable') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable

(

ID INT IDENTITY(1,1) NOT NULL

...

No loops, no cursors, no cte

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

DROP TABLE #TempTable

CREATE TABLE #TempTable

(

InvoiceId INT NOT NULL

...

oradbguru (11/28/2012)

---

Hello, I am beginning to write a procedure that will extract data from several table in XML format and apply a style sheet. I am looking for good...

I just posted a parser procedure and full-text search procedure in another thread that may be relevant:

http://www.sqlservercentral.com/Forums/Topic1389626-391-1.aspx#bm1391439

 

Here's some code I've used. I can't take full credit for the code and apologies to whoever wrote it originally. I've had it in my "toolbox" a long time.

First the...

🙂

BTW, a carpenter doesn't work without a toolbox and neither do I. If I was looking for a serious candidate I'd expect that he...

Here's an example of a procedure that takes an email address as input and outputs 0/1 if the user is expired. Of course, you can update the user's IsExpired column...

dj1202 (11/8/2012)

---

Hello everyone, I have 3 fields, all text strings but all supposed to represent dates.

Field 1: varchar in the format of '20121108'.

Field 2 and 3: varchar string...