UFN_INTERACTION_VALIDTIMEZONE

Validates that time zones are entered only when time is entered.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@TIME	UDT_HOURMINUTE	IN
@TIMEZONENTRYID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_INTERACTION_VALIDTIMEZONE
        (
            @TIME UDT_HOURMINUTE = null,
            @TIMEZONENTRYID uniqueidentifier = null
        )
        returns bit with execute as caller
        as
        begin

            if (@TIMEZONENTRYID is not null and (@TIME is null or @TIME = '')) or (@TIMEZONENTRYID is null and (@TIME is not null and @TIME <> ''))
            begin
                return 0;
            end

            return 1;

        end