USP_SIMPLEDATALIST_DESIGNATIONGOAL

            CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATIONGOAL(@DESIGNATIONID uniqueidentifier = null) 
            as

                set nocount on;

                select DESIGNATIONGOAL.ID as VALUE, DESIGNATIONLEVELGOAL.NAME as LABEL 
                from dbo.DESIGNATIONGOAL 
                inner join dbo.DESIGNATIONLEVELGOAL on DESIGNATIONGOAL.DESIGNATIONLEVELGOALID = DESIGNATIONLEVELGOAL.ID
                where DESIGNATIONGOAL.DESIGNATIONID = @DESIGNATIONID;