应收账明细_销售单_proc.sql

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

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账明细_销售单_PROC' AND TYPE='P')
DROP PROC 应收账明细_销售单_PROC
GO
create  PROC 应收账明细_销售单_PROC
@CO_TO INT,
@CO_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 销售单>=@CO_TO AND 销售单<=@CO_FR

SELECT *FROM #应收账款明细账