Hi All,
I have some clarification about my sql procedure.
MY scenario is,
I have one expected output sample xml format.
i want to create stored procedure based on the sample xml and export to the below xml format.
when i execute the stored procedure i need to get the below output,
i have tried this but i couldn't get the output.
So please drop me a solution for this. 
xml format:
 
<MAIN>
  <Data>
    <getdate>13.06.2016</getdate>
    <Doc>
      <phone>1234</phone>
    </Doc>
  </Data>
</MAIN>
 
Thanks in advance.