UFN_SPONSORSHIPOPPORTUNITYGROUP_ISINACTIVE

Returns the value of ISINACTIVE for a sponsorship opportunity group.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_SPONSORSHIPOPPORTUNITYGROUP_ISINACTIVE(
    @ID uniqueidentifier
)
returns bit
with execute as caller
as begin
    declare @ISINACTIVE bit

    select @ISINACTIVE = ISINACTIVE
    from dbo.SPONSORSHIPOPPORTUNITYGROUP
    where ID = @ID;

    return @ISINACTIVE;
end