Custom Function string_split for SQL Server 2008R2 (T-SQL split string)
For Those who have problem using string_split function in SQL Server 2008R2 CREATE FUNCTION dbo.string_split ( @stringToSplit VARCHAR(MAX), @separator VARCHAR(MAX) ) RETURNS @returnList TABLE ([value] [nvarchar] (500)) AS BEGIN DECLARE @name NVARCHAR(255) DECLARE @pos INT WHILE CHARINDEX(@separator, @stringToSplit) > 0 BEGIN SELECT @pos = CHARINDEX(@separator, @stringToSplit) SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1) INSERT INTO @returnList SELECT @name SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos) END INSERT INTO @returnList SELECT @stringToSplit RETURN END