资源描述：
《产成品入库产出明细表(仓库)su部门编码过滤不能修改》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、产成品入库产出明细表(仓库)su部门编码过滤不能修改setANSI_NULLSONsetQUOTED_IDENTIFIERONgoALTERPROCEDURE[dbo].[SP_CCCP_MX_su](--条件参数@chrWherevarchar(1000))AS--------------------------产成品入库产出明细按仓库su---------------------declare@cbDatenvarchar(10)--开始日期declare@ceDatenvarchar(10)--结束日期declare@cbrkdnvarchar(30)--起始入库单号declare@
2、cerkdnvarchar(30)--结束入库单号Declare@cbdepcodevarchar(20)--起始部门编码Declare@cedepcodevarchar(20)--结束部门编码Declare@cbcWhCodevarchar(20)--起始仓库编码cbcWhCodeDeclare@cecWhCodevarchar(20)--结束仓库编码cecWhCodeDeclare@cbinvvarchar(20)--起始存货编码Declare@ceinvvarchar(20)--结束存货编码Declare@cbclcodevarchar(20)--起始材料编码Declare@cecl
3、codevarchar(20)--结束材料编码declare@chrSqlvarchar(8000)declare@A1int,@A2int,@B1int,@B2int,@C1int,@C2int,@D1int,@D2int,@E1int,@E2int,@F1int,@F2intIF@cbdateisnullSET@cbdate='2005-10-01'IF@cedateisnullSET@cedate='2099-12-31'IF@cbrkdisnullSET@cbrkd=''IF@cerkdisnullSET@cerkd='zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz'
4、IF@cbdepcodeisnullSET@cbdepcode=''IF@cedepcodeisnullSET@cedepcode='zzzzzzzzzzzzzzzzzzzz'IF@cbcWhCodeisnullSET@cbcWhCode=''IF@cecWhCodeisnullSET@cecWhCode='zzzzzzzzzzzzzzzzzzzz'IF@cbinvisnullSET@cbinv=''IF@ceinvisnullSET@ceinv='zzzzzzzzzzzzzzzzzzzz'IF@cbclcodeisnullSET@cbclcode=''IF@ceclcodeisnullS
5、ET@ceclcode='zzzzzzzzzzzzzzzzzzzz'--获取条件IfLtrim(Rtrim(@chrwhere))<>''beginset@chrWhere=replace(@chrWhere,'cdate>=N','cdate>=')set@chrWhere=replace(@chrWhere,'cdate<=N','cdate<=')set@chrWhere=replace(@chrWhere,'crkd>=N','crkd>=')set@chrWhere=replace(@chrWhere,'crkd<=N','crkd<=')set@chrWhere=replace
6、(@chrWhere,'cdep>=N','cdep>=')set@chrWhere=replace(@chrWhere,'cdep<=N','cdep<=')set@chrWhere=replace(@chrWhere,'cWhCode>=N','cWhCode>=')set@chrWhere=replace(@chrWhere,'cWhCode<=N','cWhCode<=')set@chrWhere=replace(@chrWhere,'cinv>=N','cinv>=')set@chrWhere=replace(@chrWhere,'cinv<=N','cinv<=')set@ch
7、rWhere=replace(@chrWhere,'cclcode>=N','cclcode>=')set@chrWhere=replace(@chrWhere,'cclcode<=N','cclcode<=')SET@A1=charindex('cdate>=',@chrWhere)+8SET@A2=charindex('cdate<=',@chrWhere)+8SET@B1=charindex('crkd>=',@c
