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

 All Forums
 Site Related Forums
 Article Discussion
 Combine records of the same table, the same column

Author  Topic 

abidmisbah
Starting Member

5 Posts

Posted - 2005-01-23 : 04:54:46
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

15732 Posts

Posted - 2005-01-23 : 08:28:12
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45030
Go to Top of Page
   

- Advertisement -