fnTransactions_GetUnprocessedEventRegsForClient

            CREATE     function [dbo].[fnTransactions_GetUnprocessedEventRegsForClient](@ClientID int)

            returns table as

            return (

            select top 100 percent
            etran.EventTransactionsID,
            etran.DateAdded,
            etran.XMLObjectData,
            dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(frs.ClientUsersID) ConstituentID,
            frs.ID FundRaiserSolicitorID

            from dbo.EventTransactions etran
            --inner join dbo.ClientEvents ce on ce.ID=etran.ClientEventsID
            left join dbo.FundRaiserEventRegistrations fre on fre.EventTransactionsID=etran.EventTransactionsID
            left join dbo.FundRaiserSolicitors frs on fre.SolicitorID=frs.ID

            where
            --ce.ClientsID=@ClientID and
            etran.processed_date is null
            and etran.IsDeleted=0
            and etran.Status = 1
            and (frs.ID is null or (frs.ID is not null and frs.BackOfficeID > 0 and dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(frs.ClientUsersID) > 0))

            order by etran.EventTransactionsID
            )