Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    5

    Question Unanswered: Writing For XML Explicit Query

    I have the following table (see attachment), and I want the following XML
    document (See attachment)
    Is this possible using "FOR XML EXPLICIT" ?
    Attached Thumbnails Attached Thumbnails sql1.jpg  

  2. #2
    Join Date
    Apr 2003
    Posts
    30
    It would be easier to form the result by string manipulation.

  3. #3
    Join Date
    Jun 2003
    Posts
    5
    Originally posted by jzhu
    It would be easier to form the result by string manipulation.
    I will then get a restriction of 8000 char.
    If there are a lot of properties this will be a problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •