|
Home > Archive > SQL Anywhere database > July 2005 > list() function for ase
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
list() function for ase
|
|
|
| hi,
please anyone help me with my problem.
i like to get a query result
like this one
item 1, item 2, item 3, ......
which i can get using ASA 8 select statement:
"select list(item_desc, ', ') from item"
does anyone know how to do this in ASE?
thanks in advance.
| |
| Breck Carter [TeamSybase] 2005-07-26, 7:23 am |
| ASE doesn't offer much in the way of SQL features, and one of the many
features it doesn't offer is LIST.
For the record:
ASE 12.5 offers AVG, COUNT, MAX, MIN and SUM.
SQL Anywhere 9.0.2 offers AVG, COVAR_POP, COVAR_SAMP, COUNT, CUBE,
CUME_DIST, DENSE_RANK, GROUPING, GROUPING SETS, LIST, MAX, MIN, OVER,
PARTITION BY, PERCENT_RANK, RANGE, RANK, REGR_AVGX, REGR_AVGY,
REGR_COUNT, REGR_INTERCEPT, REGR_R2, REGR_SLOPE, REGR_SXX, REGR_SXY,
REGR_SYY, ROLLUP, ROW_NUMBER, STDDEV, STDDEV_POP, STDDEV_SAMP, SUM,
VAR_POP, VAR_SAMP and VARIANCE.
You might try writing a stored procedure containing a cursor loop to
build the list.
Breck
On 26 Jul 2005 01:04:51 -0700, ryan wrote:
>hi,
>please anyone help me with my problem.
>i like to get a query result
>like this one
>
>item 1, item 2, item 3, ......
>
>which i can get using ASA 8 select statement:
>"select list(item_desc, ', ') from item"
>
>does anyone know how to do this in ASE?
>
>thanks in advance.
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| thanks,
thats what im doin right now.
i just think i could find some other way
|
|
|
|
|