Thanks for your post... If the Table has already has INTEGER type Natural Key, would you still recommend the Surrogate Key ...

On converting the data to XML format,

Can u use function FOR XML for converting the data in to the required format; Note tag name has to be provided as...