Multiple ID insert by separating Comma

CREATE TABLE #Temp (TransactionId BIGINT)
DECLARE @END INT,@START INT=1,@LoopCount INT,@Counter INT =1,@TransactionId INT ,@TransId bigint
SET
@LoopCount= LEN(@TransIds) - LEN(REPLACE(@TransIds, ',', ''))+1
--SELECT @LoopCount
WHILE
@Counter<=@LoopCount
BEGIN
SELECT @END=CHARINDEX(',',@TransIds)-1
--PRINT @START
--PRINT @END
IF @END<0
SET @TransactionId=@TransIds
ELSE
SET @TransactionId=SUBSTRING(@TransIds,@START,@END)

-- pRINT @TransactionId
SET @Counter = @Counter+1
SET @TransIds=SUBSTRING(@TransIds,@END+2,LEN(@TransIds))
--PRINT @TransIds
INSERT INTO #Temp( TransactionId ) VALUES(@TransactionId )

select @TransId=TransactionId from #Temp

select @TransId
END