set nocount on declare @fbdate datetime , @fedate datetime , @fcustname nvarchar , @fempname nvarchar
set @fbdate=‘********‘ set @fedate=‘########‘ set @fcustname=‘@CustName@‘ set @fempname=‘@EmpName@‘
select a.fbilltype ,a.frpbank_pay , a.FStatus, a.fnumber ,a.fdate , c.fnumber as fcustnumber , c.fname as fcustname, a.famount ,a.fsettleamount , d.fnumber as fbmnumber , d.fname as fbmname , e.FNumber as fzynumber ,e.FName as fempname, a.freceiveamount , a.fpre into #temp01 from t_rp_newreceivebill a left join T_Organization c on c.FItemID=a.fcustomer left join t_department d on d.fitemid=a.fdepartment left join t_Emp e on e.FItemID=a.FEmployee
where ( a.FNumber like ‘XSKD%‘ OR A.FNumber LIKE ‘XTKD%‘) and (a.fdate>=‘********‘ or @fbdate=‘‘) and (a.fdate<=‘########‘ or @fedate=‘‘)
----对客户及业务员进行筛选：
select a.frpbank_pay, case when a.fstatus=‘7‘ then ‘发票收款核销‘ else ‘收款多发票少或无‘ end as fstatus, a.fnumber , a.fdate , a.fcustnumber ,a.fcustname, a.fbmnumber ,a.fbmname , a.fzynumber ,a.fempname, a.freceiveamount , case when a.fpre=‘0‘ then ‘收款单‘ else ‘退款‘ end as fpre from #temp01 a where (a.fempname like ‘%@EmpName@%‘ or @fempname=‘‘) and (a.fcustname like ‘%@CustName@%‘ or @fcustname=‘‘ )
---清临时表： drop table #temp01
原文：https://www.cnblogs.com/qiugy/p/11757663.html