Viewing 3 posts - 1 through 3 (of 3 total)
although rushed a more complete solution would involve extra tables for languages, Team languages, Guide languages and the Tour Day adding Language for the day: something like
August 7, 2017 at 9:54 am
-- example code for calculating working days
declare @StartDate date = '2000-01-01';
set DATEFIRST 1;
WITH
bh as
(
SELECT '2016-01-01' BankHoliday UNION ALL
SELECT '25-03-2016' BankHoliday UNION ALL
SELECT '28-03-2016' BankHoliday UNION ALL
SELECT...
June 10, 2016 at 9:32 am
I've created a table which lists dates whether they are a week day or bank holiday. I then create my own version of juilan dates which skips weekends and...
June 10, 2016 at 9:08 am
Viewing 3 posts - 1 through 3 (of 3 total)