Re: Any equivalent of LIST() function in ADS?

> > Hi Manish,
>
> > it's do***ented under
-http://manuals.sybase.com/onlinebooks/group-pbarc/conn5/sqlug/@[EMAIL
PROTECTED]
>
> > For example, consider a table X with 2 columns Y (numeric) & Z
> > (string) as follows:
>
> > Y | Z
> > --+--
> > 1 | A
> > 1 | B
> > 2 | C
> > 2 | D
> > 2 | E
>
> > then
> > SELECT Y, LIST(Z) FROM X GROUP BY Y
> > results in
>
> > Y | LIST(Z)
> > --+--------
> > 1 | A,B
> > 2 | C,D,E

Hi David,

Looks like what you need is a kind of pivot quries, you need to write
sql or proc to get kind of pivot qurey you are looking for.The below
URL got a good information about concatenating row values in T-SQL


http://www.projectdmx.com/tsql/rowconcatenate.aspx

-Manish Negandhi
[TeamSybase Intern]