问SQL如何计算每个日期的所有剩余数据

EN

CREATE FUNCTION [dbo].[GetCardDepartRemains] 
(
    @CardId INT,
    @DepartId INT,
    @Date DATETIME = NULL,
    @DocumentId INT = NULL
)
RETURNS INT
AS
BEGIN
    DECLARE @Res INT

    SELECT
        @Res = ISNULL(SUM(CASE WHEN Operations.[Output] = 0 AND Operations.RecipientId = @DepartId THEN 1 ELSE -1 END), 0)
    FROM dbo.Operations
    WHERE  Operations.CardId = @CardId
        AND (Operations.[Output] = 0 AND Operations.RecipientId = @DepartId OR Operations.Input = 0 AND Operations.SenderId = @DepartId)
        AND (@Date IS NULL OR Operations.[Date] <= @Date)

    RETURN @Res
END
GO

SELECT DISTINCT Operations.[Date] as [Date],
        Departments.Id as Depart,
        Cards.Id as [Card],
        [dbo].[GetCardDepartRemains] (Cards.Id, Departments.Id,Operations.[Date],NULL) as Res

FROM [jewellery].[dbo].[Cards] 
    CROSS JOIN [jewellery].[dbo].[Departments] 
    CROSS JOIN [jewellery].[dbo].[Operations]
WHERE [dbo].[GetCardDepartRemains] (Cards.Id, Departments.Id,Operations.[Date],NULL) = -1  

SELECT 
    [Card],
    Depart,
    Res
FROM          
    (SELECT
        Cards.Id as [Card],
        Departments.Id as Depart,
        ISNULL(SUM(CASE WHEN Operations.[Output] = 0 AND Operations.RecipientId = Departments.Id THEN 1 ELSE -1 END), 0) as Res
    FROM Operations
    CROSS JOIN Cards
    CROSS JOIN Departments
    WHERE  Operations.CardId = Cards.Id
    AND (Operations.[Output] = 0 AND Operations.RecipientId = Departments.Id OR Operations.Input = 0 AND Operations.SenderId = Departments.Id)
    AND (Operations.[Date] <= '2016-10-04') 

    GROUP BY Cards.Id, Departments.Id
    ) as X
WHERE Res = -1