ALTER procedure [dbo].[P_cht_AddDealerIds]
@TypeOneDealers varchar(max),
@subjectid int
as 
begin 

declare @split varchar(10) = ','

declare @str1 varchar(max) = @TypeOneDealers;
DECLARE @x XML
SET @x = CONVERT(XML,'<items><item id="' + REPLACE(@str1, @split, '"/><item id="') + '"/></items>')
SELECT x.item.value('@id[1]', 'INT') id into #tempa FROM @x.nodes('//items/item') AS x(item)

insert into [dbo].[cht_VendorRela](SubjectID,DealerId,IsActive,CreateTime,UpdateTime)
select @subjectid as SubjectID , b.id as DealerId , 1 , GETDATE() ,GETDATE()
from #tempa b

end