产成品入库产出明细表(仓库)su...docVIP

产成品入库产出明细表(仓库)su. with procedure SP_CCCP_MX_su tempdb..[temp_su_cpcccl] USE [UFDATA_001_2011] GO /****** 对象: StoredProcedure [dbo].[SP_CCCP_MX_su] 脚本日期: 01/25/2013 09:01:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[SP_CCCP_MX_su] ( --条件参数 @chrWhere varchar(1000) ) AS ---------------------- ----产成品入库产出明细按仓库su --------------------- declare @cbDate nvarchar (10) --开始日期 declare @ceDate nvarchar (10) --结束日期 declare @cbrkd nvarchar (30) --起始入库单号 declare @cerkd nvarchar (30) --结束入库单号 Declare @cbdepcode varchar(20) --起始部门编码 Declare @cedepcode varchar(20) --结束部门编码 Declare @cbcWhCode varchar(20) --起始仓库编码cbcWhCode Declare @cecWhCode varchar(20) --结束仓库编码cecWhCode Declare @cbinv varchar(20) --起始存货编码 Declare @ceinv varchar(20) --结束存货编码 Declare @cbclcode varchar(20) --起始材料编码 Declare @ceclcode varchar(20) --结束材料编码 declare @chrSql varchar (8000) declare @A1 int,@A2 int,@B1 int,@B2 int,@C1 int,@C2 int,@D1 int,@D2 int,@E1 int,@E2 int,@F1 int,@F2 int IF @cbdate is null SET @cbdate=2005-10-01 IF @cedate is null SET @cedate=2099-12-31 IF @cbrkd is null SET @cbrkd= IF @cerkd is null SET @cerkd=zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz IF @cbdepcode is null SET @cbdepcode= IF @cedepcode is null SET @cedepcode=zzzzzzzzzzzzzzzzzzzz IF @cbcWhCode is null SET @cbcWhCode= IF @cecWhCode is null SET @cecWhCode=zzzzzzzzzzzzzzzzzzzz IF @cbinv is null SET @cbinv= IF @ceinv is null SET @ceinv=zzzzzzzzzzzzzzzzzzzz IF @cbclcode is null SET @cbclcode= IF @ceclcode is null SET @ceclcode=zzzzzzzzzzzzzzzzzzzz --获取条件 If Ltrim(Rtrim(@chrwhere)) begin set @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(@chrWhere,cdep = N,cdep=) set @chrWhere=replace(@chrWhere,cdep = N,cdep=) set @chrWhere=replace(@chrWhere,cWhCode = N,cWhCode=)