USP_SIMPLEDATALIST_SALESORDERPREREGISTEREDREGISTRANTS

create procedure dbo.USP_SIMPLEDATALIST_SALESORDERPREREGISTEREDREGISTRANTS (@SALESORDERID uniqueidentifier)
as
    set nocount on;

    select 
        REGISTRANT.ID as VALUE, 
        REGISTRANTNAME.NAME + N' - ' + EVENT.NAME as LABEL
    from
        dbo.SALESORDERITEM
    inner join
        dbo.SALESORDERITEMTICKETREGISTRANT on SALESORDERITEMTICKETREGISTRANT.SALESORDERITEMTICKETID = SALESORDERITEM.ID
    inner join
        dbo.REGISTRANT on REGISTRANT.ID = SALESORDERITEMTICKETREGISTRANT.REGISTRANTID
    inner join
        dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
    -- Outer applying so we can sort by this value

    outer apply (
        select dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID) as NAME
    ) as REGISTRANTNAME
    where
        SALESORDERITEM.SALESORDERID = @SALESORDERID
        and REGISTRANT.WILLNOTATTEND = 0
        and REGISTRANT.ISCANCELLED = 0
    order by
        REGISTRANTNAME.NAME, EVENT.NAME, EVENT.STARTDATETIME;