Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: comma delimited results help please

    Would like to have a view created to display the result at the bottom of this message. We will be using Dreamweaver to display the information from this view. Also, for the record, we are using sql 2000. Any help would be greatly appreciated.

    tblservers
    servid servername
    1 server1
    2 server2
    3 server3

    tblapplications
    appid appname
    1 app1
    2 app2
    3 app3

    tblapplink
    id appid servid
    1 1 1
    2 1 2
    3 1 3
    4 2 1
    5 2 3
    6 3 1

    we want to display this information as below:

    appname serverlist
    app1 server1, server2, server3
    app2 server1, server3
    app3 server1

    Thank you very much,
    mrtwo

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2004
    Posts
    2

    Talking Thank you

    Thank you very much! It works just as we needed it to. We appreciate you taking time to submit a reply!!

    One big frustration down, most likely several more to go!

    Thanks again!

    mrtwo

Posting Permissions

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