UFN_RESERVATIONATTACHMENT_CONTRACTCOUNT

Returns the number of reservation attachments marked as a contract for a given reservation.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@RESERVATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_RESERVATIONATTACHMENT_CONTRACTCOUNT(@RESERVATIONID uniqueidentifier)
            returns int
            as begin
                return (select count(*) from dbo.RESERVATIONATTACHMENT where RESERVATIONID = @RESERVATIONID and ISCONTRACT = 1);
            end