CirquedeSQLeil (3/26/2010)

Steve Jones - Editor (3/26/2010)

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)

Lynn Pettis (3/26/2010)

CirquedeSQLeil (3/26/2010)

Lynn Pettis (3/26/2010)

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)

SELECT...

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

Lowell (3/25/2010)

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...

You can do this using the PIVOT operator. See this BOL link for details.

-- see how this starts off with a table and data in it?

-- if you had provided...

This link provides some information that might help you out.