tag:blogger.com,1999:blog-2904192386692843423.post7500701461517246903..comments2024-01-20T18:35:00.592+05:30Comments on IT Developer Zone: Split Function in SQLSandeep Mittalhttp://www.blogger.com/profile/02880471130771695348noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2904192386692843423.post-54796119500815341892015-07-25T10:14:16.784+05:302015-07-25T10:14:16.784+05:30Hi, thank You, it seems to be the accepted way of ...Hi, thank You, it seems to be the accepted way of doing it, very much appreciated<br />Louis van Rooyennoreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-34821006173265800212015-07-25T10:14:15.770+05:302015-07-25T10:14:15.770+05:30Hi,
This is only one value for the column. I guess...Hi,<br />This is only one value for the column. I guess, there would be many different values. How would <br />you generate columns for each value?<br /><br /><br />However after using split function you can use dynamic pivot to generate columns.<br />Refer http://bit.ly/12pEG93 for dynamic pivot.Sandeep Mittalhttp://www.itdeveloperzone.com/noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-20834997908499220482015-07-25T10:14:14.754+05:302015-07-25T10:14:14.754+05:30Than You, was hoping not toThan You, was hoping not toLouis van Rooyennoreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-6848088745796040372013-12-05T11:08:10.341+05:302013-12-05T11:08:10.341+05:30Thank you, Louis...Thank you, Louis...Sandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-15673061073798937572013-11-29T13:08:47.318+05:302013-11-29T13:08:47.318+05:30Hi one more question, I have a column with values ...Hi one more question, I have a column with values "21:20~21:28~21:28~21:40~21:40~21:40~21:42" ie tilde delim, that I now need to split into separate columns for each value. Suggestions?Sandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-26481516367864749042013-11-25T16:13:05.643+05:302013-11-25T16:13:05.643+05:30Use split function for each list and join on idUse split function for each list and join on idSandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-81089750997594192312013-11-25T13:22:27.023+05:302013-11-25T13:22:27.023+05:30Hi
Found this article helpful in resolving imports...Hi<br />Found this article helpful in resolving imports from old system, what i need to know is if you can use something similar on multiple columns instead of just oneSandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-2904192386692843423.post-75734753582142313312012-09-26T15:10:25.973+05:302012-09-26T15:10:25.973+05:30its really helpful. its really helpful. Anonymoushttps://www.blogger.com/profile/02223406348205751522noreply@blogger.com