[MSSQL] 구분자로 행으로 쪼개기 (SPLIT구현)

한열에 "한국인,미국인" 식으로 된걸 행으로 만들때 쓰임
mssql용..

CREATE FUNCTION fn_split_array(@String NVARCHAR(4000), @Delimiter CHAR(1))
RETURNS @Results TABLE (Items NVARCHAR(4000))
 AS
 BEGIN
      DECLARE @index INT
      DECLARE @slice NVARCHAR(4000)
      SELECT @index = 1
      IF @String IS NULL RETURN
      WHILE @index != 0
     BEGIN
         SELECT @index = CHARINDEX(@Delimiter,@String)
         IF @index !=0
             SELECT @slice = left(@String,@index - 1)
         ELSE
             SELECT @slice = @String
         INSERT INTO @Results(Items) VALUES(@slice)
         SELECT @String = RIGHT(@String , LEN(@String) - @index)
         IF LEN(@String) = 0 BREAK
     END  
 RETURN
 END