功能:统计未处理单据
存储过程执行时,提示错误,帮忙查看原因?谢谢!
alter PROCEDURE [dbo].[htbj_document]
AS
BEGIN
/统计单据合计/
IF exists( SELECT 1 from sys.views where object_id = object_id(N'documenttotal' ))
BEGIN
drop VIEW documenttotal
END
declare @document1 nvarchar(max);
set @document1='create view documenttotal as
select
case
when FBILLTYPEID ='93591469feb54ca2b08eb635f8b79de3' then '采购申请单'
end as 单据名称,
FBILLNO as 单据编号,
FAPPLICATIONDATE as 日期,
case
when FDOCUMENTSTATUS='a' then '创建'
when FDOCUMENTSTATUS='b' then '审核中'
when FDOCUMENTSTATUS='d' then '重新审核'
end as 单据状态,b.FNAME as 部门 ,c.FNAME as 人员
from T_PUR_Requisition a
left join T_BD_DEPARTMENT_L b on a.FAPPLICATIONDEPTID=b.FDEPTID
left join T_BD_STAFF_L c on a.FAPPLICANTID=c.FSTAFFID --任岗员工表
where (FCLOSESTATUS='A' and FDOCUMENTSTATUS='A') or ( FCLOSESTATUS='A' and FDOCUMENTSTATUS='B')
or (FCLOSESTATUS='A' and FDOCUMENTSTATUS='D')'
exec (@document1);
end
统计sql单独语句正确