title: SQL populate total working days per month minus bank holidays for current financial year
body: <p>I am after a view which will look like my first attached picture however with right hand column populated and not blank. The logic is as follows:</p>
  
  <p>The data must be for <strong>current</strong> financial period. Therfore April will be 2011 and March will be 2012 and so on. </p>
  
  <p>The calculation for Days Available for the single months will be:</p>
  
  <p>Total number of working days (Monday-Friday) minus any bank holidays that fall into that particular month, for that particular financial year (Which we have saved in a table - see second image).</p>
  
  <p>Column names for holiday table left to right: <strong>holidaytypeid</strong>, <strong>name</strong>, <strong>holstart</strong>, <strong>holend</strong>.
  Table name: <strong>holidaytable</strong></p>
  
  <p>To work out the cumulative months <strong>'Days Available'</strong> it will be a case of summing already populated data for the single months. E.g April-May will be April and May's data SUMMED and so on and so forth.</p>
  
  <p>I need the SQL query in perfect format so that this can be pasted straight in and will work (i.e with the correct column names and table names)</p>
  
  <p>Thanks for looking.</p>
  
  <p><img src="https://i.stack.imgur.com/NCxmz.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/YxVbp.jpg" alt="enter image description here"></p>