Results 1 to 1 of 1

Thread: Xml help

  1. #1
    Join Date
    Nov 2002

    Unanswered: Xml help

    need help with VB script & Xml...

    have 3 tbls.
    tblComp(PK CompId(int 4), compName, dateCreat(datetime 8)--no null)

    tblContact [PK contId(int 4), Name, {FK} CompId (int 4), MemoCount(int 4), dateEnter(datetime 8)--no null]

    tblMemo[pk memoId (int 4), {FK} contId(int 4), {FK} compId (int 4), memo (varchar 100)]

    need to write VB Script program to retrieve comp, contact, and memo and bring them together as an XML document using the FOR XML clause of the SELECT command
    Last edited by mark00189; 05-13-03 at 16:11.

Posting Permissions

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