spGetChangedApprovedClassNotes

Parameters

Parameter	Parameter Type	Mode
@ClientID	int	IN
@LastEndPoint	datetime	IN
@NewEndPoint	datetime	INOUT

Definition

Copy



    CREATE     procedure
    [dbo].[spGetChangedApprovedClassNotes](@ClientID int,@LastEndPoint datetime,@NewEndPoint datetime out)
    as
    BEGIN
    set nocount on

    select @NewEndPoint=getutcdate()

    Select 
        cyn.[ID],
        cyn.ClassNote,
        cyn.ModifiedDate 'DateLastChanged',
        cyn.[ExpireDate],
        ccy.[Name] as 'ClassYear',
        dbo.fnGetRecordIDFromLinkedUserID(cyn.OwnerID, 0) as 'RERecordID'
    from dbo.ClassYearNotes cyn
    inner join dbo.ClientClassYears ccy on cyn.ClientClassYearsID=ccy.[ID]
    where cyn.ModifiedDate > @LastEndPoint
    and cyn.ModifiedDate <=@NewEndPoint
    and cyn.IsApproved=1
    and dbo.fnGetRecordIDFromLinkedUserID(cyn.OwnerID, 0) > 0
    END