Need solution for insert multiple rows in table from comma separated string. I am able to insert in table with one column. : Declare @Var varchar(MAX)
		Set @Var = '1,2,3'
		DECLARE @XML AS XML
		DECLARE @Delimiter AS CHAR(1) =','
		SET @XML = CAST(('<X>'+REPLACE(@Var,@Delimiter ,'</X><X>')+'</X>') AS XML)		
		
		Declare @Var1 nvarchar(MAX)
		Set @Var1 = '10,11,12'
		DECLARE @XML1 AS XML
		DECLARE @Delimiter1 AS CHAR(1) =','
		SET @XML1 = CAST(('<X>'+REPLACE(@Var1,@Delimiter1 ,'</X><X>')+'</X>') AS XML)
	DECLARE @temp TABLE (ID INT,ID1 INT);
		INSERT INTO @temp (ID,ID1) values 	
			
		(SELECT N.value('.', 'INT') AS ID FROM @XML.nodes('X') AS T(N),
		SELECT N1.value('.', 'INT') AS ID1 FROM @XML1.nodes('X') AS T(N1))

		select * from  @temp