UFN_ISTEAMNAMEEXISTS

Check If the team name already exists in this event

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@NAME	varchar(200)	IN

Definition

Copy



CREATE function dbo.UFN_ISTEAMNAMEEXISTS(@EVENTID uniqueidentifier, @NAME varchar(200))
returns bit
with execute as caller
as begin
    IF EXISTS (SELECT T.ID 
                FROM dbo.TEAMFUNDRAISINGTEAM T (NOLOCK)
                INNER JOIN dbo.EVENT E (NOLOCK)
                ON T.APPEALID = E.APPEALID
                WHERE E.ID = @EVENTID and T.NAME = @NAME)
    return 1
    return 0
end