UFN_REVENUE_ISFIRSTGIFT

            create function dbo.UFN_REVENUE_ISFIRSTGIFT
            (
                @CONSTITUENTID uniqueidentifier,
                @REVENUEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as
            begin

                declare @MINDATE datetime;
                declare @MINDATEADDED datetime;

                select @MINDATE = min(REVENUE.DATE) from dbo.REVENUE where CONSTITUENTID = @CONSTITUENTID

                if (select count(ID) from dbo.REVENUE where CONSTITUENTID = @CONSTITUENTID and DATE = @MINDATE) > 1
                    begin
                        select @MINDATEADDED = min(REVENUE.DATEADDED) from dbo.REVENUE where CONSTITUENTID = @CONSTITUENTID and DATE = @MINDATE;

                        if (select DATEADDED from dbo.REVENUE where ID = @REVENUEID) = @MINDATEADDED
                            return 1;
                        else
                            return 0;
                    end
                else
                    begin
                        if (select DATE from dbo.REVENUE where ID = @REVENUEID) = @MINDATE
                            return 1;
                        else
                            return 0;
                    end

                return 0;
            end