fnTransactions_GetUnprocessedSignups

        CREATE function [dbo].[fnTransactions_GetUnprocessedSignups](@ClientID int)
            returns table as

            return (

            select top 100 percent st.SignupTransactionsID, st.DateAdded , st.XMLObjectData, st.UserID
            from dbo.SignupTransactions st, dbo.ClientUsers cu 
            where 
                st.UserID=cu.ID
                and st.clientsID = 1
                and st.processed_date is null
                and cu.deleted=0
                and (cu.active=1 or exists 
                    (select null from dbo.fundraiserdonations frd,
                    dbo.fundraisersolicitors frs
                    where frd.solicitorid = frs.id
                    and frs.clientusersid = cu.id
                    and frd.isoffline = 0)
            )
            order by st.SignupTransactionsID 
            )