Breaking News: Grepper is joining You.com. Read the official announcement!

split sql

Add Answer

Innocent Iguana answered on January 6, 2022 Popularity 9/10 Helpfulness 5/10

answer split sql

related String split in sql server

related sql Split string function

split sql

Comment

-- Assume you have the CTE
WITH cte AS (
    SELECT STRING_AGG(Country, ', ') AS ConcatenatedCountries
    FROM Country_Medals
)
SELECT value AS Country
FROM cte
CROSS APPLY STRING_SPLIT(cte.ConcatenatedCountries, ', '); -- Use STRING_SPLIT with CROSS APPLY

-- Split into words
SELECT 
    CASE 
        WHEN category LIKE '%: %' THEN SPLIT_PART(category, ': ', 1)
        WHEN category LIKE '% - %' THEN SPLIT_PART(category, ' - ', 1)
        ELSE SPLIT_PART(category, ' | ', 1)
        END AS major_category, -- alias the result
sum(businesses) -- also select number of businesses
FROM naics
GROUP BY major_category;

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 02 2024

Innocent Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

String split in sql server

Comments(1)

SELECT [Value] FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jun 14 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

sql Split string function

Comment

CREATE FUNCTION [dbo].[Func_SplitString] 
( @Values VARCHAR(MAX)
, @splitStr VARCHAR(50)
)

RETURNS @Result_Table TABLE
       (
	     [value] nvarchar(MAX) NULL
       )
BEGIN
    DECLARE @TempStr nvarchar(MAX)
    WHILE (CHARINDEX(@splitStr,@Values)>0)
    BEGIN
        SET @TempStr=SUBSTRING(@Values,1,CHARINDEX(@splitStr,@Values)-1)
        INSERT INTO @Result_Table (value) VALUES (ltrim(rtrim(isnull(@TempStr, ''))))
        SET @Values = REPLACE(@Values,@TempStr+@splitStr,'')
    END/*End While*/
	
    IF(LEN(RTRIM(LTRIM(@Values)))>0 AND CHARINDEX(@splitStr,RTRIM(LTRIM(@Values)))=0) 
    BEGIN
        SET @TempStr=@Values 
        INSERT INTO @Result_Table (value) VALUES (ltrim(rtrim(isnull(@TempStr, ''))))
    End /*End IF*/
   RETURN 
END

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 06 2022

BlackSwan

0 Answers Avg Quality 2/10

split sql

Contents

More Related Answers

split sql

Closely Related Answers

String split in sql server

sql Split string function

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.