Opinionated Software

… we have opinions about everything!

Archive for the ‘HRMS’ Category

HOLIDAY_SCHEDULE SQL —

If you come across this as one of your top (if not THE top) SQLs in your HR system: SELECT HOLIDAY_SCHEDULE, HOLIDAY, (CONVERT(CHAR(10),HOLIDAY,121)), DESCR FROM PS_HOLIDAY_DATE WHERE HOLIDAY_SCHEDULE=@P1 AND HOLIDAY=@P2 ORDER BY HOLIDAY_SCHEDULE, HOLIDAYSELECT HOLIDAY_SCHEDULE, HOLIDAY, (CONVERT(CHAR(10),HOLIDAY,121)), DESCR FROM PS_HOLIDAY_DATE WHERE HOLIDAY_SCHEDULE=@P1 AND HOLIDAY=@P2 ORDER BY HOLIDAY_SCHEDULE, HOLIDAY then look no further than the ABSW_WRK […]