USP_SIMPLEDATALIST_DESIGNATIONLEVELGOAL

Returns all goals for the given fundraising purpose.

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVELID	uniqueidentifier	IN	Fundraising Purpose

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATIONLEVELGOAL(@DESIGNATIONLEVELID uniqueidentifier = null) 
            as
                begin

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

                end