Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

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

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

abidmisbah
Starting Member

India
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.

Eg:
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

robvolk
Most Valuable Yak

USA
15732 Posts

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

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45030
Go to Top of Page
  Previous Topic Topic Next 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.08 seconds. Powered By: Snitz Forums 2000