Split SQL Strings

If you have a need to parse a string array passed in as a variable into say a stored proc, use the following function to split it: CREATE FUNCTION dbo.fnSplit( @sInputList VARCHAR(8000) — List of delimited items , @sDelimiter VARCHAR(8000)…