˪

本系统为企业进存销管理系统

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应付账款明细账_PROC' AND TYPE='P')
DROP PROC 应付账款明细账_PROC
GO
create  PROC 应付账款明细账_PROC
@vend_to varchar(10),
@vend_fr varchar(10)
as
CREATE TABLE [#应付账款明细账]
 (
	[供应商编码] [varchar] (10),
	[采购单] [int],
	[货币] [varchar] (10),
	[凭证号] [int],
	[发票号码] [varchar] (20),
	[发票日期] [datetime],
	[借方金额] [numeric](18, 6) DEFAULT (0),
	[贷方金额] [numeric](18, 6) DEFAULT (0),
	[余额] [numeric](18, 6) DEFAULT (0))


insert into #应付账款明细账 select *from 应付账款明细账
where 供应商编码>=@vend_to and 供应商编码=@vend_fr
select* from #应付账款明细账

-- EXEC 应付账款明细账_PROC 'V01','V01'