TSQL Challenge 78 - Parse single field into multiple fields

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jacob Sebastian » TSQL Challenge 78 - Parse single field into...

TSQL Challenge 78 - Parse single field into multiple fields

Rate Topic

Display Mode

Topic Options

Author

Message

jacob sebastian

Posted Sunday, March 18, 2012 10:22 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

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

.

Post #1268787

Jeff Moden

Posted Monday, March 19, 2012 1:50 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

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

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1268825

Mike Dougherty-384281

Posted Monday, March 19, 2012 7:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:20 PM
Points: 198, Visits: 678

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

Post #1268952

Sean Lange

Posted Monday, March 19, 2012 7:28 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 8,547, Visits: 8,204

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

_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1268957

Jeff Moden

Posted Monday, March 19, 2012 8:10 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

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

Post #1268984

« Prev Topic | Next Topic »

Permissions