Mar 26, 2025 · In this article, we discussed splitting single-column values into multiple-columns in SQL, focusing on the MySQL, PostgreSQL, and SQL Server databases. In MySQL, we looked at the SUBSTRING_INDEX, SUBSTRING, LOCATE, and TRIM functions.

Mar 12, 2017 · As per the most of answers I can not split my text into the column and this is the solution which I came up with. DECLARE @text varchar (30); SET @text = 'HHP:MOBILE:HHP:GSM' SELECT REVERSE(PARSENAME(REPLACE(REVERSE(@text), ':', '.'), 2)) AS CATEGORY , REVERSE(PARSENAME(REPLACE(REVERSE(@text), ':', '.'), 3)) AS SUB_CATEGORY

May 14, 2012 · Solution 2: using Split function and pivot. (the split function split a string to rows with the column name Data)

Oct 25, 2020 · This uses CHARINDEX() to find the values in the original string and then uses conditional aggregation to create the columns in order. Unfortunately, STRING_SPLIT() does not guarantee the ordering. An alternative approach is to use a recursive CTE or to mis-use the PARSENAME() function, if you don't have more than four components.

Dec 30, 2022 · in order to split a string like that into individual columns you have to first split into rows then aggregate onto columns

Aug 22, 2015 · Given below is the solution, where we need to convert the column into xml and then split it into multiple columns using delimiter. You can use any delimiter in the given below solution. In my sample, I used a blank space as a delimiter to split column into multiple columns. SET @delimiter=' ' -- <=== Here, you can change the delimiter.

Dec 30, 2024 · Learn how to parse or split SQL Server strings from one column into multiple columns using the parsename and other T-SQL functions.

Dec 3, 2020 · This article addresses the conversion of the delimited data into columns in SQL Server. There are two functions called "STRING_SPLIT" and "PARSENAME" that helps us convert the delimited data into a single and multiple columns.

Mar 26, 2024 · SQL Server introduced the STRING_SPLIT function to directly split delimited strings into a table of values. It takes the input string and delimiter as parameters, returning a table with individual items.

May 29, 2016 · To get data in columns, you can use for example pivot or max + case, something like this: select max(case when ItemNumber = 1 then Item end), max(case when ItemNumber = 2 then Item end), max(case when ItemNumber = 3 then Item end), max(case when ItemNumber = 4 then Item end), max(case when ItemNumber = 5 then Item end) from [dbo ...