sql question

#1

hi,

i need some help with this. basically, what I need is to select all of the
rows from one table in a cell

ie
col1 col2
nam1 a
nam1 b
nam1 c
nam2 a
nam2 b

I need to make it look like

nam1 a,b,c
nam2 a,b

thanks for your assistance...

#2

Hello, Akimeu

See: http://www.projectdmx.com/tsql/rowconcatenate.aspx
or:
http://databases.aspfaq.com/general/...ingle-row.html

Razvan

#3

Akimeu wrote:

Quote:

hi,

i need some help with this. basically, what I need is to select all of the
rows from one table in a cell

ie
col1 col2
nam1 a
nam1 b
nam1 c
nam2 a
nam2 b

I need to make it look like

nam1 a,b,c
nam2 a,b

thanks for your assistance...

http://sqljunkies.com/WebLog/amachan...10/5065.aspx?P...

Madhivanan

#4

Razvan Socol wrote:

Quote:

Hello, Akimeu

See: http://www.projectdmx.com/tsql/rowconcatenate.aspx
or:
http://databases.aspfaq.com/general/...ingle-row.html

Razvan

http://sqljunkies.com/WebLog/amachan...10/5065.aspx?P...

Madhivanan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sql question

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

sql question - 11-22-2006 , 03:59 PM

Re: sql question - 11-23-2006 , 04:00 AM

Re: sql question - 11-23-2006 , 07:41 AM

Re: sql question - 11-23-2006 , 07:42 AM