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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

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

  1. #1
    Join Date
    Aug 2005
    Posts
    37

    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
    Location
    Portland, OR
    Posts
    8,387
    Phil Weber
    http://www.philweber.com

    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, 07: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, 04:47 PM
  3. Get records from SQL stored Procedure
    By Mike in forum VB Classic
    Replies: 1
    Last Post: 06-17-2002, 03:13 PM
  4. Shaped Stored Procedure in SQL Server
    By Gigi in forum Database
    Replies: 0
    Last Post: 04-11-2001, 07:25 AM
  5. Replies: 3
    Last Post: 08-28-2000, 03: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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