Multiple row insertion using sqlserver

declare @id varchar(max)='1,2,3,4,5,6'
declare @Name varchar(max)='A,B,C,d,e,f'
declare @Amount varchar(max)='1000,1001,1002,1003,1004,1005'


 create table #tbl_Temp
 (
 id varchar(max),
 Name varchar(max),
 Amount varchar(max)
 )

insert into #tbl_Temp(id,Name,Amount)
select A.value[ID],B.value[Name],C.value[Amount] from 
 dbo.Udf_Split(@id,',') A  
 join dbo.Udf_Split(@Name,',') B on A.Id=B.Id
 join dbo.Udf_Split(@Amount,',') C on B.Id=C.Id


select * from #tbl_Temp
drop table #tbl_Temp

========================================================