行转换成列的方式，类似于oracle中的decode在sybase中怎么实现？

jansonwjl

我的数据是以日期和部门条件作主键存储的，也就是说：
某1部门在一个月中每天都有一条销售数据,每天的数据是一条记录,然后我要通过一个SQL语句把该月中每天的数据查询出来在一行中进行显示,请问大家这有没有什么好的办法呀?
部门1,2005.08.01,10000.00
部门1,2005.08.02,80000.00
部门1,2005.08.31,45000.00

我要显示的方式是:
部门1, 10000.00,80000.00,...45000.00

2BeSybPro

create table ctm(deptid int,transdate char(,sales money)
insert into ctm values(1,'20050801',1000.00)
insert into ctm values(1,'20050802',1650.00)
insert into ctm values(2,'20050801',2000.00)
insert into ctm values(2,'20050802',3000.00)

select distinct b.deptid,sum(b.date1) as date1,sum(b.date2) as date2
  from
(select a.deptid as deptid,(case when a.transdate='20050801' then a.sales else 0 end) as date1,(case when a.transdate='20050802' then a.sales else 0 end) as date2
  from (select distinct deptid,transdate,sum(sales) as sales
          from ctm
         group by deptid,transdate) a ) b
group by b.deptid  

if you have sales for each day, the query will be very looooooong