时间戳

首页 > 解决方案 > 将行连接到一列 sybase

sql - 将行连接到一列 sybase

问题描述

我当前数据库的功能有限。我有一个场景，我需要将行连接到 SYBASE 中的一列

LETTER
A
B
C
D

EXPECTED RESULT
A,B,C,D

你能帮我么？

标签： sqlsybase

解决方案

我使用了这种形式...根据您的需要进行更改！

declare @w_caracter_val varchar(2),
        @w_contador smallint,
        @w_registros smallint,
        @w_caracterFinal varchar(30)
--Crear tabla temporal        
create table #sb_caracteres   
             (se_id            int identity,
              codigo           varchar(10))
--insert a la tabla #                                
insert into #sb_caracteres
           (codigo)
    select  codigo        
     from cr_corresp_sib  
    where tabla = 'T260'   

--select * from #sb_caracteres
select @w_registros = (select count(1)from  #sb_caracteres)
select @w_contador = 1
select @w_caracterFinal= ''

while @w_contador <= @w_registros 
begin
    select   @w_caracter_val = codigo             
    from #sb_caracteres  
    where se_id = @w_contador

print 'codigo %1!, %2!',  @w_contador, @w_caracter_val

--select @w_caracterFinal= concat(@w_caracterFinal,@w_caracter_val)

select @w_caracterFinal = ltrim(rtrim(@w_caracterFinal)) + ltrim(rtrim(@w_caracter_val))   

select @w_caracterFinal
--print 'registros %1!',  @w_caracterFinal
Select @w_contador = @w_contador +1
end

推荐阅读