Operation Details |
Description: | Method to return all records after a specified date |
Sterotype: | nsmulti |
SQL |
SELECT userCalendarID, userName, nonWorkingDate, nonWorkingDayType, assignToUser, reason INTO :userCalendarID, :userName, :nonWorkingDate, :nonWorkingDayType, :assignToUser, :reason FROM UserCalendar WHERE userName = :userName AND nonWorkingDate >= :startDate AND nonWorkingDate <= :endDate ORDER BY nonWorkingDate |