I've got a table which contains a series of dates (the columns are client_id, start_date and end_date). I need to calculate the number of working days between the start and end dates. This count needs to exclude weekends and bank holidays. I've created a table called tbl_holidays which contains a list of all UK bank holidays (the columns are hol_name (eg. xmas day) and hol_date). Can this be done using sql?