USP_DATALIST_EVENTTASKREMINDERALERT

CREATE procedure dbo.USP_DATALIST_EVENTTASKREMINDERALERT
as
    set nocount on;

    select
        EVENTTASKREMINDER.ID as 'ID'
        , EVENTTASKREMINDER.NAME as 'REMINDERNAME'
        , EVENTTASKREMINDER.SENDDATE as 'REMINDERDATE'
        , EVENTTASK.NAME as 'SUBJECT'
        , EVENTTASK.COMMENT as 'NOTES'
        , convert(nvarchar(8), EVENTTASK.COMPLETEBYDATE, 112) as 'DATEDUE'
        , NF.NAME as 'OWNER'
        , EVENT.NAME as 'PARENTRECORDNAME'
        , APPUSER.ID as 'APPUSERID'
        , EVENT.ID as 'LINKCONTEXTRECORDID'
        , convert(uniqueidentifier, '9988B807-97B2-434C-8BE1-BBEE6B944B2C') as 'EMAILBODYCONTEXTLINKPAGEID'
    from
        dbo.EVENT
        inner join dbo.EVENTTASK on
            (EVENT.ID = EVENTTASK.EVENTID)
        inner join dbo.EVENTTASKREMINDER on
            (EVENTTASK.ID = EVENTTASKREMINDER.EVENTTASKID)
        inner join dbo.APPUSER on
            (EVENTTASK.OWNERID = APPUSER.CONSTITUENTID)
        cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTTASK.OWNERID) NF
    where
        (EVENTTASKREMINDER.SENDDATE < getdate())
        and (EVENTTASKREMINDER.SENT = 0)
        and (EVENTTASK.STATUSCODE = 0);

    return 0;