UFN_PROGRAM_GETLASTSCHEDULEID

            create function dbo.UFN_PROGRAM_GETLASTSCHEDULEID(@ID uniqueidentifier)
            returns uniqueidentifier
            with execute as caller
            as begin
                declare @SCHEDULEID uniqueidentifier;
                declare @EVENTDATEADDED datetime;
                declare @CONFLICTSCHEDULEID uniqueidentifier;
                declare @CONFLICTDATEADDED datetime;

                select top 1
                    @SCHEDULEID = SCHEDULEID,
                    @EVENTDATEADDED = DATEADDED
                from
                    dbo.EVENT
                where
                    PROGRAMID = @ID
                    and SCHEDULEID is not null
                order by
                    DATEADDED desc;

                select top 1
                    @CONFLICTSCHEDULEID = SCHEDULEID,
                    @CONFLICTDATEADDED = DATEADDED
                from
                    dbo.EVENTCONFLICT
                where
                    PROGRAMID = @ID
                    and SCHEDULEID is not null
                order by
                    DATEADDED desc;

                if @CONFLICTDATEADDED > @EVENTDATEADDED
                    return @CONFLICTSCHEDULEID;

                return @SCHEDULEID;
            end