Sybase 반복문 효과 쿼리

set rowcount 0
declare @index numeric(3)
declare @rows  numeric(4)
declare @cont varchar(2000)
declare @cd  char(3)

drop table #TEMP00

select A.CD, A.CD_NM, isnull(B.CNT,0) CNT
into #TEMP00
from AM_IA_CD A,
(select ORG_CD, DISP_KIND_CD, COUNT(*) as CNT
from AM_IDEN_DISP
where ORG_CD = '090000000000' and YEAR = '2005'
group by ORG_CD, DISP_KIND_CD) B
where A.ORG_CD = B.ORG_CD
      AND A.CD = B.DISP_KIND_CD
     AND  A.CD_TYPE = 'TO03'
and A.ORG_CD = '090000000000'  and CD!='000000000'

set @index =1
set @cd  = '000'
select @rows   = count(*) from #TEMP00

set rowcount 1
while (@index <= @rows   )
begin
select @cd =  CD from #TEMP00 where CD > @cd

select @cont =  @cont + (case when @index>1 then ',' end) + CD_NM + ' ' + convert(varchar,CNT) + '건'  from #TEMP00
                              where CD > @cd
select @index = @index+1
                             
end

select @cont
drop table #TEMP00
set rowcount 0