UFN_EDUCATIONALMAJOR_GETNAME

Returns a list of majors 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_EDUCATIONALMAJOR_GETNAME(@EDUCATIONALHISTORYID uniqueidentifier)
            returns nvarchar(255)
            as begin
                declare @LIST nvarchar(255);

                select @LIST = dbo.uda_buildlist(MAJORCODE.DESCRIPTION)
                from dbo.EDUCATIONALMAJORCODE as MAJORCODE
                inner join dbo.EDUCATIONALMAJOR as MAJOR on MAJORCODE.ID = MAJOR.EDUCATIONALMAJORCODEID
                where MAJOR.EDUCATIONALHISTORYID = @EDUCATIONALHISTORYID;

                return @LIST;
            end