UFN_CAMPAIGNHIERARCHYGOAL_GETNAME

Retrieve the name of the campaign hierarchy goal with the given ID.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNHIERARCHYGOALID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CAMPAIGNHIERARCHYGOAL_GETNAME
            (
                @CAMPAIGNHIERARCHYGOALID uniqueidentifier
            ) returns nvarchar(100)
            as 
            begin
                declare @GOALNAME nvarchar(100)

                select @GOALNAME=NAME
                from CAMPAIGNHIERARCHYGOAL
                where ID=@CAMPAIGNHIERARCHYGOALID

                return @GOALNAME
            end