IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_發(fā)票與入庫單匹配' AND TYPE='P')
DROP PROC PROC_發(fā)票與入庫單匹配
GO
CREATE  PROC PROC_發(fā)票與入庫單匹配
AS
CREATE TABLE #AA
(采購單號 INT,
發(fā)票金額 NUMERIC,
增值稅額 NUMERIC)
INSERT INTO #AA (采購單號,發(fā)票金額,增值稅額 )  
SELECT 采購單號, SUM(發(fā)票金額),SUM(增值稅額) 
 FROM 采購入庫單明細(xì)表  GROUP BY 采購單號

DECLARE PP3  SCROLL CURSOR FOR 
    SELECT 采購單號,發(fā)票金額,增值稅額 FROM #AA
    OPEN PP3
DECLARE @采購單號 INT, @發(fā)票金額 NUMERIC(18,6), @增值稅額  NUMERIC(18,6)
    FETCH PP3 INTO @采購單號,@發(fā)票金額,@增值稅額 
WHILE @@FETCH_STATUS=0
BEGIN
  UPDATE 供應(yīng)商發(fā)票 SET 已分配材料金額=已分配材料金額+@發(fā)票金額,已分配增值稅=已分配增值稅+@增值稅額 WHERE  采購單號=@采購單號
FETCH PP3 INTO @采購單號,@發(fā)票金額,@增值稅額 
     END   
    CLOSE PP3
    DEALLOCATE PP3
-- EXEC PROC_發(fā)票與入庫單匹配