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.