Author Topic: How to concatenate a column? Any idea?  (Read 186 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 228
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
How to concatenate a column? Any idea?
« on: August 23, 2008, 04:59:13 PM »
I have a requirement. Can you help me guys?

I need to concatenate a column from multiple rows into a single column in a new table.
Is this possible?

Sample:
Given:
SID NAME CATGROUP
------------------------------------------------------------
4476 03 CLOTHING ACTIVE
4476 03 CLOTHING DANCE
4476 03 CLOTHING LWR

Need to have

SID NAME CATGROUP
------------------------------------------------------------
4476 02 CLOTHING ACTIVE , DANCE, LWR


Thanks a lot

Techronnati | where technology never sleeps

How to concatenate a column? Any idea?
« on: August 23, 2008, 04:59:13 PM »

Mountain View

Offline JusticeLeague

  • Sr. Member
  • *
  • Posts: 359
  • Karma: +1/-0
    • View Profile
Re: How to concatenate a column? Any idea?
« Reply #1 on: August 23, 2008, 05:20:04 PM »
Well you can try Creating a user-defined function based on this algorithm: http://sqlblindman.googlepages.com/crea ... tedstrings

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
110 Views
Last post November 08, 2008, 12:14:10 PM
by LadyProgrammer
0 Replies
84 Views
Last post July 14, 2016, 05:38:16 AM
by GBTalk
2 Replies
106 Views
Last post November 25, 2016, 09:52:58 AM
by nomadic
1 Replies
122 Views
Last post December 14, 2016, 11:38:34 AM
by JusticeLeague
0 Replies
24 Views
Last post September 19, 2017, 03:02:47 AM
by rpmolecule

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.