Stunner01225
Technical User
I have a SQL database with one table. I need to take this information and place it into a hierarchy. I am new to SQL server 2000’s XML functions and relatively new to XSLT. I do not know which technology is should use.
The situation is as follows.
The One table handles a case. For example
<Case ID><Case Owner><Case Status><Case Description>
I need this in the following hierarchy
<Case Owner >
<Case Status>
<Case Description Case ID>
A Case Status is Open or Closed And there are currently only twenty Case Owners.
I have never used For XML statements before but I know that For XML explicit can place it into hierarchies, I just do not know how. I have used XSLT before, but I am not sure if it has the power to take this flat data and turn it into a hierarchy.
Thank you in advance for any help
The situation is as follows.
The One table handles a case. For example
<Case ID><Case Owner><Case Status><Case Description>
I need this in the following hierarchy
<Case Owner >
<Case Status>
<Case Description Case ID>
A Case Status is Open or Closed And there are currently only twenty Case Owners.
I have never used For XML statements before but I know that For XML explicit can place it into hierarchies, I just do not know how. I have used XSLT before, but I am not sure if it has the power to take this flat data and turn it into a hierarchy.
Thank you in advance for any help