I'm ready for it! Judging solely by some of the posts where you have utilized it,...

steve-893342 (3/27/2010)

---

Sorry folks, can't leave this one alone. I have come up with another variation, which like Wayne's, uses the TALLY table to do both the split and...

CirquedeSQLeil (3/26/2010)

---

Steve Jones - Editor (3/26/2010)

---

Lynn,

I think you need to ignore the posts that aren't on topic in the cert thread. Just skip them like they are not present.

I wish...

The Dixie Flatline (3/26/2010)

---

I sometimes wonder if there is a role for PASS in certifying people as having a specific level of expertise, not experience. It doesn't...

Lynn Pettis (3/26/2010)

---

CirquedeSQLeil (3/26/2010)

---

Lynn Pettis (3/26/2010)

---

At this point, I'm ending this conversation. Let this thread get back on topic, which is The Missing Certification.

I am more than willing to...

You're going to have to use the data conversion transformation to put it in the proper format.

FYI, the easiest way is to use the "Export Data" wizard in SSMS, specify...

Nice Paul, very nice! No tally table at all, just using CharIndex's ability to get the next occurrence. And, of course, your always-present CROSS APPLY 😀

Good job. I also learned...

declare @test varchar(50)

set @test = 'qhonboenoqenfpgqonfnoibnqogqofqqf'

select right(@test, 10)

tesker (3/25/2010)

---

I've found several examples of how to use the CASE statement to do this but for some reason I cannot get it to work. Here is my SQL:

SELECT...

Sounds like if you blinked, you missed it. See why you should have a permanent tally table?!? 🙂

Lowell (3/25/2010)

---

nice breakthrough Wayne; I couldn't get my mind around the multiple ranges;

performance on this solution sux, took my decent dev machine 1:09 to return the 151 rows, we might...

It would be really helpful if, based on the sample data provided (BTW, thanks for that!), if you would supply what the expected output would be.

-- See how this starts off by creating a table

-- and inserting representative test data into it?

-- If you do this, it makes it a LOT easier for all

--...

No problem. On the other hand, it's been a little bit slow for...

Slick,

I took Lutz' code, added the other product fields, and it works fine. One thing to remember, when dealing with XML, is that it is CaSe SeNsItIvE.

DECLARE @xml XML

SET @xml=(SELECT...