UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCORE

Returns the core curricula in a add requests process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCORE( @ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID uniqueidentifier )
returns table
as return(

    select 
        ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCURRICULUM.ID,
        ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCURRICULUM.CORECURRICULUMID,
        NAME
    from 
        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCURRICULUM
    inner join CORECURRICULUM
        on CORECURRICULUM.ID = ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCURRICULUM.CORECURRICULUMID
    where 
        ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID = @ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID

    )