TSQL convert csv to table

BlackSwan answered on January 21, 2022 Popularity 9/10 Helpfulness 1/10

answer TSQL convert csv to table

TSQL convert csv to table

Comment

CREATE FUNCTION [dbo].[CSV2TABLE] (@InStr nvarchar(MAX))
RETURNS @TempTab TABLE
   (id nvarchar(MAX) NOT NULL)
AS
BEGIN
    
	SET @InStr = REPLACE(@InStr + ',', ',,', ',')
	DECLARE @SP INT
	DECLARE @VALUE nvarchar(MAX)

	WHILE PATINDEX('%,%', @INSTR ) <> 0 
	BEGIN
  	 SELECT  @SP = PATINDEX('%,%',@INSTR)
  	 SELECT  @VALUE = LEFT(@INSTR , @SP - 1)
  	 SELECT  @INSTR = STUFF(@INSTR, 1, @SP, '')
   	INSERT INTO @TempTab(id) VALUES (@VALUE)
END
	RETURN
END

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: csv sql

Link to this answer
Share Copy Link

Contributed on Jan 21 2022

BlackSwan

0 Answers Avg Quality 2/10

TSQL convert csv to table

Contents

More Related Answers

TSQL convert csv to table

Grepper

Documentation

Social

Legal

Contact

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