ALTER FUNCTION [CDN].[Prf_sumafaktur](@WkZ2_GUID INT)
returns @T TABLE(
  sumakwota     MONEY,
  sumapozostaje MONEY)
AS
  BEGIN
      DECLARE @sumaKwota INT
      DECLARE @sumaPozostaje INT
      DECLARE kursor CURSOR FOR
        SELECT wkz2_gidtyp,
               wkz2_gidnumer,
               wkz2_gidlp
        FROM   cdn.wkrzaznaczenia2
        WHERE  wkz2_guid = @WkZ2_GUID
      DECLARE @WkZ2_GIDTyp   INT,
              @WkZ2_GIDNumer INT,
              @WkZ2_GIDLp    INT

      OPEN kursor

      FETCH next FROM kursor INTO @WkZ2_GIDTyp, @WkZ2_GIDNumer, @WkZ2_GIDLp

      WHILE @@FETCH_STATUS = 0
        BEGIN
            UPDATE @T
            SET    sumakwota = sumakwota + CONVERT(MONEY, a.trp_kwota),
                   sumapozostaje = sumapozostaje
                                   + CONVERT(MONEY, a.trp_pozostaje)
            FROM   cdn.traplat a
            WHERE  a.trp_gidtyp = @WkZ2_GIDTyp
                   AND a.trp_gidnumer = @WkZ2_GIDNumer
                   AND a.trp_gidlp = @WkZ2_GIDLp
        END

      FETCH next FROM kursor INTO @WkZ2_GIDTyp, @WkZ2_GIDNumer, @WkZ2_GIDLp

      CLOSE kursor

      DEALLOCATE kursor

      RETURN
  END