USP_DATALIST_STUDENT_SKILL_GRADELEVEL

CREATE procedure dbo.USP_DATALIST_STUDENT_SKILL_GRADELEVEL
(
    @ONLYCURRENT bit = 0
)
as
    set nocount on;

    declare @CURRENTDATE datetime
    if @ONLYCURRENT = 1
        set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

    select 
        STUDENTSKILL.ID,
        STUDENTSKILLGRADELEVEL.ID as STUDENTSKILLGRADELEVELID,
        GRADELEVEL.DESCRIPTION as GRADELEVEL,
        STUDENTSKILL.NAME as SKILLNAME,
        STUDENTSKILLRATINGGROUP.NAME as RATINGNAME,
        @CURRENTDATE,--STUDENTSKILL.STARTDATE,

        @CURRENTDATE,--STUDENTSKILL.ENDDATE, 

        '' as STUDENTSKILLMARKINGCOLUMNS
       --(select stuff(( select '; ' + MARKINGCOLUMNDESCRIPTIONCODE.DESCRIPTION

       --        from dbo.STUDENTSKILLMARKINGCOLUMN

       --            join dbo.MARKINGCOLUMNDESCRIPTIONCODE on MARKINGCOLUMNDESCRIPTIONCODE.ID = STUDENTSKILLMARKINGCOLUMN.MARKINGCOLUMNDESCRIPTIONCODEID

       --        where STUDENTSKILLMARKINGCOLUMN.STUDENTSKILLID = STUDENTSKILL.ID

       --        order by MARKINGCOLUMNDESCRIPTIONCODE.SEQUENCE

       --        for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, '')) as STUDENTSKILLMARKINGCOLUMNS

    from dbo.STUDENTSKILLGRADELEVEL
        join dbo.STUDENTSKILL on STUDENTSKILL.ID = STUDENTSKILLGRADELEVEL.STUDENTSKILLID
        join dbo.GRADELEVEL on GRADELEVEL.ID = STUDENTSKILLGRADELEVEL.GRADELEVELID
        join dbo.STUDENTSKILLRATINGGROUP on STUDENTSKILLRATINGGROUP.ID = STUDENTSKILL.STUDENTSKILLRATINGGROUPID
    --where @CURRENTDATE is null or (STUDENTSKILL.STARTDATE <= @CURRENTDATE and (STUDENTSKILL.ENDDATE is null or @CURRENTDATE <= STUDENTSKILL.ENDDATE))

    --order by GRADELEVEL.SEQUENCE, STUDENTSKILL.STARTDATE, STUDENTSKILL.NAME