SQLServerCentral / Discuss Content Posted by Jacob Sebastian / Article Discussions / Article Discussions by Author / TSQL Challenge 78 - Parse single field into multiple fields / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 08:53:34 GMT20RE: TSQL Challenge 78 - Parse single field into multiple fieldshttp://www.sqlservercentral.com/Forums/Topic1268787-356-1.aspxI 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.Mon, 19 Mar 2012 08:10:50 GMTJeff ModenRE: TSQL Challenge 78 - Parse single field into multiple fieldshttp://www.sqlservercentral.com/Forums/Topic1268787-356-1.aspxLOL. Forget about efficiency I want this in a single query no matter how slow!!! :-DMon, 19 Mar 2012 07:28:03 GMTSean LangeRE: TSQL Challenge 78 - Parse single field into multiple fieldshttp://www.sqlservercentral.com/Forums/Topic1268787-356-1.aspx[quote][b]Jeff Moden (3/19/2012)[/b][hr]This is another contest problem where the best solution wouldn't likely be an "all in one" query.[/quote]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. :)Mon, 19 Mar 2012 07:23:27 GMTMike Dougherty-384281RE: TSQL Challenge 78 - Parse single field into multiple fieldshttp://www.sqlservercentral.com/Forums/Topic1268787-356-1.aspxThis is another contest problem where the best solution wouldn't likely be an "all in one" query.Mon, 19 Mar 2012 01:50:52 GMTJeff ModenTSQL Challenge 78 - Parse single field into multiple fieldshttp://www.sqlservercentral.com/Forums/Topic1268787-356-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/T-SQL+Challenges/89062/">TSQL Challenge 78 - Parse single field into multiple fields</A>[/B]Sun, 18 Mar 2012 22:22:12 GMTjacob sebastian