splitting a column in to 3 columns

Question

splitting a column in to 3 columns

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

Jeff Moden (3/2/2011)
Simple 2, 3, or 4 part splits seem to come up a lot. What'cha figure? "SQL Spackle" article worthy?

Yes, definitely.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Jeff Moden (3/2/2011)
Thanks for the feedback, folks. Simple 2, 3, or 4 part splits seem to come up a lot. What'cha figure? "SQL Spackle" article worthy?

Sure. At least script of the day.

It has such a nice and short layout, instead of a long clumsy findchar/substring combination.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP