USP_SIMPLEDATALIST_FAF_GROUPBYEVENT_NOPARENT

create procedure dbo.USP_SIMPLEDATALIST_FAF_GROUPBYEVENT_NOPARENT 
(
  @EVENTID uniqueidentifier = null
)
as

  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
  and t.PARENTTEAMID is null
    order by LABEL asc