USP_DATALIST_STUDENT_BYLASTINITIAL

Returns a list of students with a given last initial.

Parameters

Parameter	Parameter Type	Mode	Description
@LASTINITIAL	nvarchar(1)	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_STUDENT_BYLASTINITIAL(@LASTINITIAL nvarchar(1))
as
    set nocount on;

    select CONSTITUENT.ID,
           CONSTITUENT.NAME + case when CONSTITUENT.NICKNAME <> ''
                                then ' (' + CONSTITUENT.NICKNAME + ')'
                                else ''
                              end as NAME,
           GRADELEVEL.DESCRIPTION as GRADE
    from dbo.STUDENT
        join dbo.CONSTITUENT                on CONSTITUENT.ID = STUDENT.ID
        join dbo.EDUCATIONALHISTORY         on EDUCATIONALHISTORY.CONSTITUENTID = STUDENT.ID
        join dbo.STUDENTPROGRESSION         on STUDENTPROGRESSION.ENROLLMENTID = EDUCATIONALHISTORY.ID
        join dbo.SCHOOLGRADELEVEL           on SCHOOLGRADELEVEL.ID = STUDENTPROGRESSION.SCHOOLGRADELEVELID
        join dbo.GRADELEVEL                 on GRADELEVEL.ID = SCHOOLGRADELEVEL.GRADELEVELID
    where 
        CONSTITUENT.KEYNAME like @LASTINITIAL + '%'
        and not (STUDENTPROGRESSION.ENDDATE < getdate() or STUDENTPROGRESSION.STARTDATE > getdate())
    order by 
        CONSTITUENT.KEYNAME, 
        CONSTITUENT.FIRSTNAME