辉煌处理资产负债表不平

期初是平的，但是后面做账过程中资产负债表不平了，执行一下脚本
DECLARE @atypeid VARCHAR(25),@ATOTAL NUMERIC(22,10)
SELECT a.atypeid ,
SUM(ISNULL(b.total, 0)) Total
INTO #temp
FROM dbo.atype a
LEFT JOIN dbo.DlyA b ON a.atypeid = b.atypeid
WHERE a.asonnum = 0
GROUP BY a.atypeid
ORDER BY a.atypeid
DECLARE AtypeTotal_Cursor CURSOR FOR SELECT * FROM #temp
OPEN AtypeTotal_Cursor
FETCH NEXT FROM AtypeTotal_Cursor INTO @atypeid , @aTotal
WHILE @@FETCH_STATUS = 0
BEGIN
IF EXISTS(SELECT 1 FROM dbo.atype WHERE atypeid = @atypeid)
BEGIN
IF @atypeid LIKE '00004%'
UPDATE dbo.atype SET Total = @aTotal WHERE atypeid = @atypeid
ELSE
UPDATE dbo.atype SET Total = @aTotal WHERE atypeid = @atypeid
END
FETCH NEXT FROM AtypeTotal_Cursor INTO @atypeid , @aTotal
END
CLOSE AtypeTotal_Cursor
DEALLOCATE AtypeTotal_Cursor
DROP TABLE #temp
go
售前咨询：400-636-0579