UFN_DESIGNATION_GETGOALS

This function returns the goals for a designation given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_DESIGNATION_GETGOALS(@DESIGNATIONID uniqueidentifier)
        returns table
        as return
            select
                DESIGNATIONGOAL.ID as ID,
                ISNULL(DESIGNATIONGOAL.DESIGNATIONLEVELGOALID, DESIGNATIONLEVELGOAL.ID) as DESIGNATIONLEVELGOALID,
                DESIGNATIONLEVELGOAL.NAME as NAME,
                DESIGNATIONGOAL.GOAL as GOAL,
                DESIGNATIONLEVELGOAL.STARTDATE as STARTDATE,
                DESIGNATIONLEVELGOAL.ENDDATE as ENDDATE,
                DESIGNATIONGOAL.BASECURRENCYID as BASECURRENCYID
            from
                dbo.DESIGNATIONLEVELGOAL
                left join dbo.DESIGNATIONGOAL on DESIGNATIONLEVELGOAL.ID = DESIGNATIONGOAL.DESIGNATIONLEVELGOALID
            where
                DESIGNATIONGOAL.DESIGNATIONID = @DESIGNATIONID