USP_SIMPLEDATALIST_DESIGNATIONLEVELGOAL_DESIGNATION

            create procedure dbo.USP_SIMPLEDATALIST_DESIGNATIONLEVELGOAL_DESIGNATION(@DESIGNATIONID uniqueidentifier = null) 
            as
                begin

                declare @DESIGNATIONLEVELID uniqueidentifier;
                select @DESIGNATIONLEVELID = DESIGNATIONLEVEL1ID
                from dbo.DESIGNATION
                where DESIGNATION.ID = @DESIGNATIONID;

                select DESIGNATIONLEVELGOAL.ID as VALUE, DESIGNATIONLEVELGOAL.NAME as LABEL 
                from dbo.DESIGNATIONLEVELGOAL 
                where DESIGNATIONLEVELGOAL.DESIGNATIONLEVELID = @DESIGNATIONLEVELID;

                end