proc_

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

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_销售记账凭证' AND TYPE='P')
DROP PROC PROC_销售记账凭证
GO
CREATE PROC PROC_销售记账凭证
@CO_ID INT
AS
INSERT INTO 销售记账凭证( 销售订单,客户编码,发票金额, 增值税金额)
SELECT 销售单号,客户编码,SUM(发票金额),SUM(增值税额)
FROM  销售出库单明细表  WHERE 销售单号=@CO_ID  GROUP BY 销售单号,客户编码
-- EXEC PROC_销售记账凭证 1
--  SELECT *FROM  销售记账凭证