sql - How can i customize an XML from data table? -


How do I customize XML from the data table? Or can I get XML optimized directly from SQL Server

Edit:?. I am getting some line in my data table, which I need to customize in the following format

    

Later, using some APIs, some PHP sites will be read by the site, but confused with it should also save server-generated XML, which I will display it on a web page PHP site will be read.

EDIT: Some such data line is just one line, I'm just copying hte feilds.

  id CompanyName DoctorName1 DoctorName2 DoctorName3 AddressLine1 AddressLine2 AddressLine3 AddressCity AddressProvince AddressCountry AddressPostal CompanyPhone CompanyFax website PrimaryContact PrimaryEmail ShortDescription LongDescription HoursSunday HoursMonday HoursTuesday HoursWednesday HoursThursday HoursFriday HoursSaturday ProgEssBodyToxin ProgEssNerve ProgEssWellness ProgEssOxygen ProgEssMax ProgMLHealthCenter ProgWellness AffiliateID PaymentVisa PaymentMasterCard PaymentAMEX PaymentCheck Latitude Longitude    

What is a SQL Server 2008 which gives you the proper customized XML string , What do you mean if you optimize If you provide some samples, then some reasonable answer can be given.

Comments