USP_SIMPLEDATALIST_DESIGNATION_APPEAL

            CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATION_APPEAL(@APPEALID uniqueidentifier = null) 
            as
                begin

                select DESIGNATION.ID as VALUE, DESIGNATION.USERID as LABEL, APPEALDESIGNATION.ISDEFAULT as DESCRIPTION
                from dbo.APPEALDESIGNATION
                inner join dbo.DESIGNATION
                    on APPEALDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                where APPEALDESIGNATION.APPEALID = @APPEALID
                order by APPEALDESIGNATION.ISDEFAULT desc, DESIGNATION.USERID;

                end