应收账明细_凭证_proc.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 20 行

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账明细_凭证_PROC' AND TYPE='P')
DROP PROC 应收账明细_凭证_PROC
GO
create  PROC 应收账明细_凭证_PROC
@VOU_TO INT,
@VOU_FR INT
AS 
CREATE TABLE [#应收账款明细账] (
	[客户编码] [varchar] (10)  ,
	[销售单] [int]  ,
	[货币] [varchar] (10) ,
	[凭证号] [int],
	[发票号码] [varchar] (20)  ,
	[发票日期] [datetime] ,
	[借方金额] [numeric](18, 6),
	[贷方金额] [numeric](18, 6),
	[余额] [numeric](18, 6))
INSERT INTO #应收账款明细账 SELECT* FROM 应收账款明细账
WHERE 凭证号>=@VOU_TO AND 凭证号<=@VOU_FR