UFN_STUDENTPROGRESSION_GETADVISORNAMES

Returns a comma separated list of advisor names for a given student progression.

Return

Return Type
nvarchar(400)

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTPROGRESSIONID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_STUDENTPROGRESSION_GETADVISORNAMES(
            @STUDENTPROGRESSIONID uniqueidentifier
        )
        returns nvarchar(400)
        with execute as caller
        as begin
            declare @advisornames nvarchar(400)

            set @advisornames = ''
            select
                @advisornames = CASE @advisornames WHEN '' THEN dbo.CONSTITUENT.[NAME] ELSE @advisornames + '; ' + dbo.CONSTITUENT.[NAME] END
            from 
                dbo.STUDENTADVISOR
                inner join dbo.CONSTITUENT on dbo.STUDENTADVISOR.[FACULTYID] = dbo.CONSTITUENT.[ID]
            where 
                dbo.STUDENTADVISOR.[STUDENTPROGRESSIONID] = @STUDENTPROGRESSIONID

            return @advisornames
        end