USP_DATALIST_APPEALDESIGNATIONS

Displays a list of designations for an appeal.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                create procedure dbo.USP_DATALIST_APPEALDESIGNATIONS (@ID uniqueidentifier)
                as begin

                    set nocount on;

                    select 
                        APPEALDESIGNATION.ID,
                        APPEALDESIGNATION.DESIGNATIONID,
                        DESIGNATION.NAME DESIGNATIONNAME,
                        APPEALDESIGNATION.ISDEFAULT
                    from
                        dbo.APPEALDESIGNATION
                        inner join dbo.DESIGNATION on APPEALDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                    where
                        APPEALDESIGNATION.APPEALID = @ID
                    order by
                        DESIGNATION.NAME;

                end