USP_SIMPLEDATALIST_TAXDECLARATIONALIAS

create procedure dbo.USP_SIMPLEDATALIST_TAXDECLARATIONALIAS (
    @CONSTITUENTID uniqueidentifier = null
) as
    select
        ALIAS.ID as VALUE,
        coalesce(ALIASTYPECODE.DESCRIPTION + ' ', '') + '(' + ALIAS.NAME + ')' as LABEL
    from dbo.ALIAS
    left outer join dbo.ALIASTYPECODE on ALIASTYPECODE.ID = ALIAS.ALIASTYPECODEID
    where ALIAS.CONSTITUENTID = @CONSTITUENTID
    order by
        ALIASTYPECODE.DESCRIPTION, ALIAS.KEYNAME, ALIAS.NAME