帮忙看一下这个存储过程为什么调用时报不能返回数据集。
CREATE procedure ReportzhuxueJinFx
@Nj varchar(20),
@bj varchar(30)
As
declare @sNum int
Declare @sqNum int
declare @sPnum int
Begin
select @sNum=count(*) From xs_Xuesheng where nj=@Nj and Bj=@Bj
IF @sNum>0
begin
select @sqNum=Count(*) From xs_zhuxueje where nj=@nj and Bj=@bj
IF @sqNum>0
begin
select @spNum=Count(*) From xs_zhuxueje where nj=@nj and Bj=@bj and spdate=Null and spr=Null
select max(@nj) as 年级,max(@bj) as 班级,@sNum as 班级总人数,@sqNum as 审请人助学金人数,@sqNum/@sNum*100 as
审请比例, @spNum/@sQnum*100 as 审批比例 From xs_zhuxueJe
end
End
end
GO