USP_DATALIST_CHECKGROUPNAMES
Gets all the group names for an event
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | Event ID |
| @ROLETYPE | tinyint | IN | Role type |
| @NAME | varchar(200) | IN | Team Name |
| @CHECKPREVIOUS | bit | IN | Check previous event |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_CHECKGROUPNAMES
(
@EVENTID uniqueidentifier,
@ROLETYPE tinyint = 1, -- 1: Team, 2: Company, 3: Household
@NAME varchar(200) = null,
@CHECKPREVIOUS bit = 0
)
as
set nocount on;
DECLARE @PRIORYEAREVENTID uniqueidentifier
IF @CHECKPREVIOUS = 1
SELECT @PRIORYEAREVENTID = PRIORYEAREVENTID
FROM dbo.EVENTEXTENSION WITH (NOLOCK) WHERE EVENTID = @EVENTID
SELECT
T.ID,
T.NAME
FROM dbo.TEAMFUNDRAISINGTEAM T
LEFT OUTER JOIN dbo.TEAMEXTENSION TE
ON T.ID = TE.TEAMFUNDRAISINGTEAMID
INNER JOIN dbo.EVENT E WITH (NOLOCK)
ON T.APPEALID = E.APPEALID
WHERE
(TE.EVENTID = @EVENTID
OR TE.EVENTID = @PRIORYEAREVENTID )
AND TE.TYPECODE = @ROLETYPE
AND T.NAME = ISNULL(@NAME,T.NAME)