How to export XML using stored procedure in SQL server?

See more:

SQL

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.

What I have tried:

how to export xml using stored procedure in sql server?