sqlserver 3a can we select from comma seperated string variable value

Solutions on MaxInterview for sqlserver 3a can we select from comma seperated string variable value by the best coders in the world

Search
showing results for - "sqlserver 3a can we select from comma seperated string variable value"
Maximilian
20 May 2018
1/****** Object:  UserDefinedFunction [dbo].[CSVToTable]    Script Date: 04/28/2013 10:45:17 ******/
2SET ANSI_NULLS ON
3GO
4
5SET QUOTED_IDENTIFIER ON
6GO
7
8CREATE FUNCTION [dbo].[CSVToTable] (@InStr VARCHAR(MAX))
9RETURNS @TempTab TABLE
10   (id int not null)
11AS
12BEGIN
13    ;-- Ensure input ends with comma
14	SET @InStr = REPLACE(@InStr + ',', ',,', ',')
15	DECLARE @SP INT
16DECLARE @VALUE VARCHAR(1000)
17WHILE PATINDEX('%,%', @INSTR ) <> 0 
18BEGIN
19   SELECT  @SP = PATINDEX('%,%',@INSTR)
20   SELECT  @VALUE = LEFT(@INSTR , @SP - 1)
21   SELECT  @INSTR = STUFF(@INSTR, 1, @SP, '')
22   INSERT INTO @TempTab(id) VALUES (@VALUE)
23END
24	RETURN
25END
26GO
source
similar questions
sql server 2016 split stringsql server separar numeros por comas milesget value comma separated sql serversearch from comma separated values in sql serverfetcht he leftmost word in a comma separated string in sqlsql server select top 1 assign to variablevariables in select statement in sql serverreplace multiple string in query sqlsql join on comma separated fieldcomma seperated join mssqlexample of sql querry result sepapreted by commasplit string by comma in sql serversql server 3a concatinate column value without trailing or leading commasql select into variablesql split comma separated string into rowssql split string by spacerows to comma separated values in mssqlsql server 3a select column values as comma separated stringsql var that stores the number of lines changedsql server 3a how to concatenate column data using commasql server split string and insert into table selectsql column values comma separatedsql server concat string and intcreate table split string function in sql serversql integer devision
queries leading to this page
sql select result into comma separated stringcreate comma seperated string from select results sqlsql parameter comma separated listsql server select rows from comma separated string to tableselect values as comma separated sqlsql comma separated list whereuse in for comma separated string sqlsql select as comma separated stringcomma seperated string check in sqlselect in comma separated sqlhow to select comma separated vaues in sqlwhere clause in sql with comma separated valuesget comma separated values in sql serverhow to use comma separated values in sqlsql use comma seperated string in statemtnselect comma separated values in sqlselect column values as comma separated string in sql serverselect data as comma separated sqlselect data comma separated in sqlusing comma separated list in sqlin 28 29 clauses expect a comma separated list of valuessqlserver 3a can we select from comma seperated string variable value