IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_銷售發票與出庫單匹配' AND TYPE='P')
DROP PROC PROC_銷售發票與出庫單匹配
GO
create  PROC PROC_銷售發票與出庫單匹配
as
CREATE TABLE #AA
(
銷售單號 INT,
發票金額 NUMERIC(18,6),
增值稅額 NUMERIC(18,6))
INSERT INTO #AA (銷售單號,發票金額,增值稅額 )  
SELECT 銷售單號, SUM(發票金額),SUM(增值稅額) 
 FROM 銷售出庫單明細表  GROUP BY 銷售單號
declare PP3  SCROLL cursor for 
    select 銷售單號,發票金額,增值稅額 from #AA
SELECT *FROM #AA
    open PP3
DECLARE @銷售單號 INT, @發票金額 NUMERIC(18,6), @增值稅額  NUMERIC(18,6)
    fetch PP3 into @銷售單號,@發票金額,@增值稅額 
while @@fetch_status=0
begin
  update 銷售發票 set 已分配發票金額=已分配發票金額+@發票金額,已分配增值稅=已分配增值稅+@增值稅額   where  銷售單號=@銷售單號
           fetch PP3 into @銷售單號,@發票金額,@增值稅額 
     end   
    close PP3
    deallocate PP3
-- SELECT *FROM 銷售發票

-- EXEC  PROC_銷售發票與出庫單匹配