UFN_RESERVATION_FINALCOUNTPASTDUE

Returns a bit describing if the final count of visitors is past due on a reservation.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_RESERVATION_FINALCOUNTPASTDUE(@ID uniqueidentifier)
            returns bit
            with execute as caller
            as begin
                declare @FINALCOUNTREQUIRED bit;
                declare @FINALCOUNTDUEDATE date;
                declare @FINALCOUNTRECEIVED bit;
                declare @CURRENTDATE date;

                set @CURRENTDATE = getdate();

                select @FINALCOUNTREQUIRED = FINALCOUNTREQUIRED,
                    @FINALCOUNTDUEDATE = FINALCOUNTDUEDATE,
                    @FINALCOUNTRECEIVED = FINALCOUNTRECEIVED
                from dbo.RESERVATION
                where ID = @ID;

                if (@FINALCOUNTREQUIRED = 1) and (@FINALCOUNTDUEDATE < @CURRENTDATE) and (@FINALCOUNTRECEIVED = 0)
                    return 1;

                return 0;
            end