USP_SIMPLEDATALIST_FAF_GROUPBYEVENT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_FAF_GROUPBYEVENT
(
@EVENTID uniqueidentifier = null
)
as
-- select cast('00000000-0000-0000-0000-000000000001' as uniqueidentifier) as VALUE, 'All groups' as LABEL
--select NULL as VALUE, 'All groups' as LABEL
-- union all
select T.ID AS VALUE,
T.NAME AS LABEL
from dbo.TEAMFUNDRAISINGTEAM T
inner join dbo.TEAMEXTENSION TE ON TE.TEAMFUNDRAISINGTEAMID = T.ID
where TE.EVENTID = @EVENTID
order by LABEL asc