sql问题，100分的

[wqmgxj]

http://topic.csdn.net/u/20100520/16/1b999f17-1c5a-4901-b264-633436347b5f.html?54908

[thinclient]

帮顶给分不?

[永生天地]

sybase不支持自定义函数，没办法

[htl258_Tony]

你可以参考临时表和游标的方法试试

[hhwydwfg]

ddd

[keepever3948]

--游标
use sybase
create table tb
(
Id int,
value varchar(50),
)
insert into tb values('1','aa')
insert into tb values('1','bb')
insert into tb values('2','aaa')
insert into tb values('2','bbb')
insert into tb values('2','ccc')
go
declare @AA varchar(50)
declare @BB varchar(50)
declare @CC varchar(50)

declare my_cursor cursor for select value from tb
open my_cursor
fetch next from my_cursor into @AA
fetch next from my_cursor into @BB
select Id ,value=(@AA+','+@BB ) from tb where value=@BB
fetch next from my_cursor into @AA
fetch next from my_cursor into @BB
fetch next from my_cursor into @CC
select Id,value=(@AA+','+@BB+','+@CC) from tb where value=@AA
close my_cursor
deallocate my_cursor
drop table tb

[keepever3948]

已经测试过了,可用,楼主可以试试.

[keepever3948]

sybase啊,我自建的数据库中测试的,刚学,是不是我搞错了....