spSolicitorEventRegistration

    CREATE   PROCEDURE dbo.spSolicitorEventRegistration
        (
            @SolicitorID int
        )
    AS
        SELECT     frer.[ID],
            frer.[SolicitorID],
            frer.[Amount],
            frer.[EventTransactionsID],
            frer.[CurrencyType],
            et.[DateAdded],
            et.processed_date DateProcessed,
            et.IsDeleted
            from FundRaiserEventRegistrations frer
            inner join EventTransactions et on et.EventTransactionsID = frer.EventTransactionsID
            WHERE SolicitorID = @SolicitorID

    RETURN