IF (SELECT COUNT(*) FROM AAA WHERE DW = @DW AND JH = @JH AND HBRQ < @HBRQ AND DRJS IS NOT NULL AND DRJS <> 0) > 0 BEGIN SET @QRJS = (SELECT DRJS FROM AAA WHERE DW = @DW AND JH = @JH AND HBRQ =(SELECT MAX(HBRQ) FROM AAA WHERE DW = @DW AND JH = @JH AND HBRQ < @HBRQ AND DRJS IS NOT NULL AND DRJS <> 0) )
IF @QRJS > @DRJS SET @DRJC = 0 ELSE SET @DRJC = @DRJS - @QRJS END ELSE SET @DRJC = @DRJS --========================== RETURN(@DRJC) END
@JH VARCHAR(100),
@HBRQ DATETIME,
@DRJS NUMERIC(7,2))
RETURNS NUMERIC(7,2) ASBEGIN
DECLARE
@QRJS NUMERIC(7,2),
@QDATE DATETIME, --上一次的记录时的日期
@DDATE DATETIME, --本次记录时的日期
@DRJC NUMERIC(7,2)
IF (SELECT COUNT(*) FROM AAA WHERE DW = @DW AND JH = @JH AND HBRQ < @HBRQ AND DRJS IS NOT NULL AND DRJS <> 0) > 0
BEGIN
SET @QRJS = (SELECT DRJS
FROM AAA
WHERE DW = @DW AND
JH = @JH AND
HBRQ =(SELECT MAX(HBRQ)
FROM AAA
WHERE DW = @DW AND
JH = @JH AND
HBRQ < @HBRQ AND
DRJS IS NOT NULL AND
DRJS <> 0) )
IF @QRJS > @DRJS
SET @DRJC = 0
ELSE
SET @DRJC = @DRJS - @QRJS
END
ELSE
SET @DRJC = @DRJS
--==========================
RETURN(@DRJC)
END