Esperando querybills

Hemos avanzado en el proyecto hemos llegado hacer los SP de intereses y los movimientos no aplicados a aplicados

Codigo:
CREATE PROCEDURE [dbo].[ARSP_QueryBills]
-- Add the parameters for the stored procedure here
@Loan INT,
@SortWay INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

DECLARE @BillsPerLoan TABLE(BillDate DATE,PayDate DATE,Fee MONEY,MonthInterests MONEY,Amortization MONEY);

BEGIN TRY
IF @SortWay = 1
BEGIN
INSERT INTO @BillsPerLoan(BillDate,PayDate,Fee,MonthInterests,Amortization)
SELECT B.Date,B.PayDate,B.Fee,B.MonthInterests,B.Amortization
FROM dbo.Bill B
WHERE ((B.FK_Loan = @Loan) AND (B.FK_BillStatus = 1))
ORDER BY B.Date ASC
END

ELSE IF @SortWay = 2
BEGIN
INSERT INTO @BillsPerLoan(BillDate,PayDate,Fee,MonthInterests,Amortization)
SELECT B.Date,B.PayDate,B.Fee,B.MonthInterests,B.Amortization
FROM dbo.Bill B INNER JOIN dbo.Loan L ON B.FK_Loan = L.ID
WHERE ((B.FK_Loan = @Loan) AND (B.FK_BillStatus = 1))
ORDER BY L.FK_Debtor ASC
END

ELSE
BEGIN
INSERT INTO @BillsPerLoan(BillDate,PayDate,Fee,MonthInterests,Amortization)
SELECT B.Date,B.PayDate,B.Fee,B.MonthInterests,B.Amortization
FROM dbo.Bill B
WHERE ((B.FK_Loan = @Loan) AND (B.FK_BillStatus = 1))
ORDER BY B.FK_BankAgent ASC
END

SELECT BillDate,PayDate,Fee,MonthInterests,Amortization
FROM @BillsPerLoan
RETURN 1
END TRY

BEGIN CATCH
RETURN @@ERROR * -1
END CATCH

END

GO
horas de realización: 3 horas