USP_SIMPLEDATALIST_SALESORDERITEMREGISTRANTS

CREATE procedure dbo.USP_SIMPLEDATALIST_SALESORDERITEMREGISTRANTS
(
    @SALESORDERITEMTICKETID uniqueidentifier = null
)
as
    select 
        REGISTRANTID as VALUE,
        dbo.UFN_CONSTITUENT_BUILDNAME(REGISTRANT.CONSTITUENTID) as LABEL
    from dbo.SALESORDERITEMTICKETREGISTRANT
    inner join dbo.REGISTRANT on REGISTRANT.ID = SALESORDERITEMTICKETREGISTRANT.REGISTRANTID
    where SALESORDERITEMTICKETID = @SALESORDERITEMTICKETID
    order by REGISTRANT.ISCANCELLED asc, LABEL asc