get record in xml and multiple record insert into table using xml in sql server

Declare @XmlOutput xml
set @XmlOutput=(SELECT IDNumber,LoginId FROM tblTest where LoginId=2 FOR XML AUTO,Root('Product'), ELEMENTS)
select @XmlOutput
---return record in xml format

DECLARE @idoc INT

EXEC sp_xml_preparedocument @idoc OUTPUT, @XmlOutput
INSERT INTO tblTest(IDNumber,LoginId)

SELECT IDNumber,LoginId
FROM Openxml( @idoc, '/Product/tblTest', 3) WITH ( IDNumber int, LoginId int )

SET NOCOUNT OFF