Insert Multiple Rows Into SQL Table

I am trying to insert multiple rows into a table getting data from a web form.





I have 2 fields being passed from a web form to the below stored procedure


@FormBidlistID Sample Data --> 500


@CheckBoxListContractors Sample Data --> 124,125,145,154,156,





The below DELETE function is working great. However for some reason or another the INSERT INTO sql command is not putting seperating the string and adding rows to the database? I am not sure where the error is occuring.





In the end I need the data to go into the database columns like so





Table: BidlistContractors (2 Columns: BidlistID, ContractorID)





BidlistID ContractorID


500 124


500 125


500 145


500 154


500 156





Stored Procedure Code:





CREATE PROCEDURE dbo.UpdateBidlistContractors


@FormBidlistID int,


@CheckBoxListContractors varchar(3999)


AS


DELETE FROM BidlistContractors


WHERE BidlistID = @FormBidlistID


DECLARE @ContractorID nvarchar(10)


DECLARE @BidlistID nvarchar(10)


DECLARE @startPosition int


DECLARE @commaPosition int


SET @startPosition =1


SET @commaPosition = 0


WHILE (@startPosition < LEN(@ContractorID))


BEGIN


SET @commaPosition = CHARINDEX(' , ' , @ContractorID, @startPosition)


SET @ContractorID= SUBSTRING(@ContractorID, @startPosition, @commaPosition - @startPosition)


INSERT INTO BidlistContractors (BidlistID, ContractorID)


VALUES (@BidlistID, @ContractorID)


SET @startPosition = @startPosition + LEN(@ContractorID) + 1


END


GO








Where am I going wrong? Thank you in advance for any help.


:-)