Scenario
The health care provider requires a list of patients and their specilaist doctors. The specialist are doctors to whom the doctor refers for any particular tests or treatment.
Operation
The SQL/XML function XMLQUERY can query on parts of an XML document. It enables XML data to participate in SQL queries.
Solution
A report of the patients and their specialists is generated effeciently.