UFN_AUCTIONITEM_DONATIONDATENOTAFTEREXPIRATIONDATE

Ensures that an item's expiration is not before it's donation date.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEAUCTIONDONATIONID	uniqueidentifier	IN
@EXPIRATIONDATE	datetime	IN

Definition

Copy



            create function dbo.UFN_AUCTIONITEM_DONATIONDATENOTAFTEREXPIRATIONDATE
            (
                @REVENUEAUCTIONDONATIONID uniqueidentifier,
                @EXPIRATIONDATE datetime
            )
            returns bit
            with execute as caller
            as begin
                declare @VALID bit;
                declare @DONATIONDATE datetime;
                select @DONATIONDATE = REVENUE.DATE from dbo.REVENUE
                    where REVENUE.ID = @REVENUEAUCTIONDONATIONID

                if @DONATIONDATE > @EXPIRATIONDATE
                    set @VALID = 0;
                else
                    set @VALID = 1;

                return @VALID;
            end