MS-SQL- 복수 인자값, 파싱, 루프돌려 처리

ms-sql sP

 --// CAT_ID 추출
 SELECT @CAT_ID = CAT_ID FROM TB_CATEGORY WHERE CH_ID=@ch_id and CAT_ORDER=@cat_order and CAT_NAME=@cat_name

 --// 복수개의 일자ID 를 SPLIT 하여 TB_CAT_DAY 에 INSERT
 IF @snd_day_id<>''
  BEGIN
   WHILE CHARINDEX(',', @snd_day_id) <> 0
    BEGIN
     INSERT INTO TB_CAT_DAY (SND_DAY_ID, CAT_ID) VALUES (SUBSTRING(@snd_day_id,1,CHARINDEX(',',@snd_day_id)-1), @cat_id)
     
     SET @snd_day_id=SUBSTRING(@snd_day_id,CHARINDEX(',',@snd_day_id)+1,LEN(@snd_day_id))
     
     IF CHARINDEX(',', @snd_day_id) = 0
      BREAK
     ELSE
      CONTINUE
    END
  END