UFN_STEWARDSHIPPLANSTEP_VALIDTARGETTIME

Validates that times are entered only when time zone 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_STEWARDSHIPPLANSTEP_VALIDTARGETTIME
(
    @TIME UDT_HOURMINUTE = null,
    @TIMEZONENTRYID uniqueidentifier = null
)
returns bit with execute as caller
as
begin
    if (@TIMEZONENTRYID is null and (@TIME is not null and @TIME <> ''))
    begin
        return 0;
    end

    return 1;

end