--创建一个函数：(tbl--表名，no--编号，direc--方向，Num--数量)create function getList(@sNo varchar(10),@sDirec varchar(10))return varchar(1000)asdeclare @sList varchar(1000)declare @iNum intdeclare cur cusor for select Num from tab where No = @sNo and Direc = @sDirecopen curfetch next from cur into @iNumwhile @@fetch_status = 0begin set @sList = @sList + '+' + cast(@iNum as varchar(10))fetch next from cur into @iNumendclose curdeallocate curreturn @sListgo--要得到你想要的结果，执行如下语句：select no,getList(no,'卖出') as sale,getList(no,'买入') as buy from (select distinct no from tbl)
