【SQL开源代码栏目提醒】:本文主要为网学会员提供GetVoucherNotBalance.sql,希望对需要GetVoucherNotBalance.sql网友有所帮助,学习一下!
CREATE FUNCTION GetVoucherNotBalance
(
@BeginVoucDate Char(8),
@EndVoucDate Char(8)
)
RETURNS TABLE
AS
RETURN
SELECT VoucID, VoucDate
FROM VoucMaster
WHERE VoucDate >= @BeginVoucDate AND VoucDate <= @EndVoucDate
AND VoucDRAmount <> VoucCRAmount