CREATE proc Get_InvCurrentstock_Detail1(@cWhcode varchar(20)='',@cInvCode varchar(20)='',@date1 varchar(12)='1900-01-01',@Date2 varchar(12)='2099-12-31',
@cWhcode1 varchar(20)='',@cInvCCode varchar(20)='',@cWhcode2 varchar(20)='',@cWhcode3 varchar(20)='',@cWhcode4 varchar(20)='',@cWhcode5 varchar(20)='',@cWhcode6 varchar(20)='',@cWhcode7 varchar(20)='' )
as
begin
--if exists (select 1 from Sysobjects where name='RdrecordsByRdCode' and xtype='u')
--drop table RdrecordsByRdCode
--if exists (select 1 from Sysobjects where name='RdrecordsByRdCode_result' and xtype='u')
--drop table RdrecordsByRdCode_result
declare @iPeriod int
declare @iYPeriod varchar(10)
set @iYPeriod= convert(varchar(4),year(@date1))
+left('00',2-len(convert(varchar(2),month(@date1))))+convert(varchar(2),month(@date1))
select @iPeriod=max(iYPeriod) from gl_mend where cast(iYPeriod as int)<@iYperiod and bflag_st=1 and iperiod <>0
declare @date_Begin varchar(12)
select @date_Begin=Convert(varchar(10),dateadd(day,1,dEnd),120) from ufsystem..ua_period
where cAcc_Id= N'002' and iyear = left(@iPeriod,4) and iid= right(@iPeriod ,2)
--select @iYPeriod,@iPeriod,@date_begin,@date1,@date2
set @date_Begin=isnull(@date_begin,'2000-01-01')
--采购入库单
select id into #rdrecord01 from rdrecord01 RdRecord where 1=1 and ((RdRecord.dDate < '2012-10-24' And IsNull(RdRecord.bIsSTQc,0) = 1)
Or (RdRecord.dDate >= '2012-10-24'
And IsNull(RdRecord.bPUFirst,0) = 0
And IsNull(RdRecord.bIAFirst,0) = 0
And IsNull(RdRecord.bOMFirst,0) = 0