OPENXML(MS-SQL SP)

declare @doc_xml xml
declare @idnyn int
select @doc_xml = originalxml, @idnyn = idn from doc where idn =@idn

declare @idoc_new int
if @idnyn <> ''
begin
set @idoc_new = 1
EXEC sp_xml_preparedocument @idn OUTPUT, @doc_xml
end
else
begin
set @idoc_new = 0
end

SELECT *
INTO #tmpTable
FROM OPENXML (@idn, '/*[local-name()=''Sanofi'']/*[local-name()=''Content'']', 2)
WITH (
ProductCode varchar(100) './*[local-name()=''ProductCode'']',
ProductName varchar(100) './*[local-name()=''ProductName'']',
ProductType varchar(100) './*[local-name()=''ProductType'']',
Material varchar(100) './*[local-name()=''Material'']',
MaterialType varchar(100) './*[local-name()=''MaterialType'']',
Version varchar(100) './*[local-name()=''Version'']',
Requester varchar(100) './*[local-name()=''Requester'']',
ReasonforChange varchar(100) './*[local-name()=''ReasonforChange'']',
PackType varchar(100) './*[local-name()=''PackType'']'
)

select * from #tmpTable
drop table #tmpTable

if @idoc_new = 1
begin
EXEC sp_xml_removedocument @idn
end