TSQL Challenge 78 - Parse single field into multiple fields

Question

Post reply

TSQL Challenge 78 - Parse single field into multiple fields

jacob sebastian

SSChampion

Points: 11822
More actions
March 18, 2012 at 10:22 pm

#270130

Comments posted to this topic are about the item TSQL Challenge 78 - Parse single field into multiple fields
.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

This is another contest problem where the best solution wouldn't likely be an "all in one" query.

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

Mike Dougherty-384281 SSCrazy Points: 2794 More actions · Answer 2

Jeff Moden (3/19/2012)
This is another contest problem where the best solution wouldn't likely be an "all in one" query.

I suggest the schema should be redesigned and this code would be part of a one-time fix to populate new tables rather than part of ongoing reporting.

I know... this is a vendor's application, entrenched business, just get it done "for today", and a dozen other reasons why we all still have jobs dealing with other people's implementation choices. 🙂

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

LOL. Forget about efficiency I want this in a single query no matter how slow!!! 😀

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 4

I know it's just a contest and a lot of the problems are made up but I really worry about things like this. Judging from the number of people with performance questions on this site and the folks/problems I run into in real life, there are enough people that don't understand how bad all-in-one queries can be.

I liked (haven't been there in a while) Phil Factor's "Speed Phreak" challenges a lot better. They allowed folks to use some very effective "Divide-n-Conquer" methods.

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