zgh_产品日报表.docVIP

--产品日报表 --exec Get_Product_Day ,0,2010-10-01,0 alter proc Get_Product_Day @NodeKey nvarchar(100), @ID int, @FDate varchar(10), @FStoreID int=0 as set nocount on declare @Count int declare @FSQEDate datetime --上期结存时间 declare @strSql varchar(8000) if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[Temp_Product_Day]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[Temp_Product_Day] CREATE TABLE [dbo].[Temp_Product_Day] ( [FID] [int] IDENTITY (1, 1) NOT NULL , [FProductID] [int] NULL , [FDayInNumber] [float] default (0) NULL , [FDayInPiece] [float] default (0)