Convert the XML to temp table using OPENXML in SQL Server

DECLARE @idoc int

DECLARE @doc varchar(1000)

SET @doc ='

<OutLookContact>

<Contact FirstName="Asif" LastName="Ghafoor" EmailAddress1="asifghafoor@my.web.pk" />

<Contact FirstName="Rameez" LastName="Ali" EmailAddress1="rameezali@my.web.pk" />

</OutLookContact>'

--Create an internal representation of the XML document.

EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

-- Execute a SELECT statement that uses the OPENXML rowset provider.

DECLARE @Temp TABLE(FirstName VARCHAR(250),LastName VARCHAR(250),Email1 VARCHAR(250))  

INSERT INTO @Temp(FirstName,LastName,Email1)

SELECT *

FROM OPENXML (@idoc, '/OutLookContact/Contact',1)

WITH (FirstName varchar(50),LastName varchar(50),EmailAddress1 varchar(50))

select FirstName,LastName,Email1 from @Temp