my xml file is
<Date>05/11/2004
     <UserName> admin
         <FormName>frmErrorReport
             <Procedure>PrcEDIT
                     <ErrorNo>0</ErrorNo>
                     <ErrorDescription />aaaa
             </Procedure>
         </FormName>
     </UserName>
</Date>

i want to convert this in sql server as a temporary table
the sql i used is
************************************************** ******
DECLARE @xmlDoc VARCHAR(8000)
DECLARE @xmlHandle INT
BEGIN
    SET @xmlDoc =
'
     <Date>05/11/2004
     <UserName> admin
         <FormName>ErrorReport
             <Procedure>PrcEDIT
                     <ErrorNo>0</ErrorNo>
                     <ErrorDescription />aaaa
             </Procedure>
         </FormName>
     </UserName>
</Date>


'

    EXEC sp_xml_preparedocument @xmlHandle OUTPUT, @xmlDoc
    SELECT * FROM OPENXML (@xmlHandle, '/Date/UserName/FormName/procedure/errorNo/ErrorDescription',6) WITH
        (
            date1 varchar(20),
            UserName varchar(20),
            FormName varchar(20),
            Procedure1 varchar(20),
                        errorNo varchar(20),
                        ErrorDescription varchar(20)
)

    -- Important to specify this
    EXEC sp_xml_removedocument @xmlHandle
END

*****************************************

its returning only null values

anybody knows the answer plz help


Milan

Your XPath does not match your document in terms of capitalisation, e.g. etc.


--

Joe (Co-author Beginning XML, 3rd edition)

<Date>05/11/2004
     <UserName> admin
          <FormName>frmErrorReport
               <Procedure>PrcEDIT
                     <ErrorNo>0</ErrorNo>
                     <ErrorDescription />aaaa
               </Procedure>
          </FormName>
     </UserName>
 </Date>
actually i need a file like above so can u tell me the correct xpath