SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Combine records of the same table, the same column
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

5 Posts

Posted - 01/23/2005 :  04:54:46  Show Profile  Send abidmisbah a Yahoo! Message
hi, i have all my portal contents on the SQL Database in the following manner:
Node_id Contents
12 this the first page
12 welcome to the portal
12 this is some sample data
13 this the second page,
13 sample data

when a page is being loaded, depending on the node_id contents are retrieved and displayed. Now i need a query which would combine all records of the same Node_id (page) and display as one record.

Node_id Contents
12 this the first page welcome to the portal this is...
13 this is the second page, sample data

Anyone with a solution, please post a reply. thank you

Most Valuable Yak

15729 Posts

Posted - 01/23/2005 :  08:28:12  Show Profile  Visit robvolk's Homepage
Please do not cross post:

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000