UFN_EDUCATIONALMINOR_GETNAME

Returns a list of minors for a given constituent's educational history.

Return

Return Type
nvarchar(255)

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALHISTORYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EDUCATIONALMINOR_GETNAME(@EDUCATIONALHISTORYID uniqueidentifier)
            returns nvarchar(255)
            as begin
                declare @LIST nvarchar(255);

                select @LIST = dbo.uda_buildlist(MINORCODE.DESCRIPTION)
                from dbo.EDUCATIONALMAJORCODE as MINORCODE
                inner join dbo.EDUCATIONALMINOR as MINOR on MINORCODE.ID = MINOR.EDUCATIONALMAJORCODEID
                where MINOR.EDUCATIONALHISTORYID = @EDUCATIONALHISTORYID;

                return @LIST;
            end