create row for comma seperate

Question

create row for comma seperate

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

gideon.kahl SSC-Addicted Points: 489 More actions · Answer 1

WayneS (6/29/2010)Out of curiousity, did you use the first solution as it's written, or did you follow the recommendation to build your very own tally table with a clustered index (100% FillFactor) and run the code against that?

As it was written with the tally table being created in the CTE. I did the test using a table with 2000 comma seperated lists.

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 2

gideon.kahl (6/29/2010)
WayneS (6/29/2010)Out of curiousity, did you use the first solution as it's written, or did you follow the recommendation to build your very own tally table with a clustered index (100% FillFactor) and run the code against that?
As it was written with the tally table being created in the CTE. I did the test using a table with 2000 comma seperated lists.

What were the test results and did you test any other methods on the same data while you were at it? Can you post your test jig code?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)