Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Turn comma-separated numbers in string into rows
-- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <A function that splits comma separated numbers in string> -- ============================================= CREATE FUNCTION [dbo].[fnSplitValues] ( @IDs nvarchar(max) ) RETURNS @SplitValues TABLE ( ID int ) AS BEGIN -- Fill the table variable with the rows for your result set DECLARE @xml xml SET @xml = N'<root><r>' + replace(@IDs,',','</r><r>') + '</r></root>' INSERT INTO @SplitValues(ID) SELECT r.value('.','int') FROM @xml.nodes('//root/r') as records(r) RETURN END GO SELECT * FROM [dbo].[fnSplitValues]('1,2,3')
run
|
edit
|
history
|
help
0
replace string
New
Select empID whose salary is greater than their managers
Update Temp table to Insert node in XML data using SQL
Create and Insert Command Example
Print 10 records
Query Anisa YP
Elena-Tests
Combined Where and having
t1