DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005

    Could you write a special stored procedure for me in SQL 2005?

    When I execute the SQL "select TagName from Th_TagTable where IDTopic=@IDTopic" , it return several rows such as
    TagName= http://www.hothelpdesk.com
    TagName= http://www.hellocw.com
    TagName= http://www.supercoolbookmark.com

    I hope there is a stored procedure which can join all TagName into a single string and return,
    it means when I pass @IDTopic to the stored procedure, it return "http://www.hothelpdesk.com, http://www.hellocw.com, http://www.supercoolbookmark.com"

    How can write the stored procedure?

  2. #2
    Join Date
    Nov 2003
    Portland, OR
    Phil Weber

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Replies: 1
    Last Post: 04-24-2008, 06:03 AM
  2. How to hide SQL Server Stored procedure from the users
    By software_develo in forum Database
    Replies: 3
    Last Post: 12-09-2005, 03:47 PM
  3. Get records from SQL stored Procedure
    By Mike in forum VB Classic
    Replies: 1
    Last Post: 06-17-2002, 02:13 PM
  4. Shaped Stored Procedure in SQL Server
    By Gigi in forum Database
    Replies: 0
    Last Post: 04-11-2001, 06:25 AM
  5. Replies: 3
    Last Post: 08-28-2000, 02:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.