CREATE TABLE #Tmp_ID(
	ID INT NOT NULL)

WHILE @SYSID > ''
BEGIN
	IF (SELECT PATINDEX('%,%',@SYSID)) > 0--check for a comma
	BEGIN
		--get the first part
		INSERT INTO #Tmp_FacID
		SELECT SUBSTRING(@SYSID,1,PATINDEX('%,%',@SYSID)-1)
	
		--reset the string
		SELECT @SYSID = SUBSTRING(@SYSID,PATINDEX('%,%',@SYSID)+1,LEN(@SYSID))
	END
	--now insert final val
	ELSE
	BEGIN
		INSERT INTO #Tmp_FacID
		SELECT @SYSID

		--reset str
		Select @SYSID = ''
	END
END