SQL Server adding a record record manually to a view
- by SelectDistinct
I have a view which contains the data seen in the image below.
The view is showing me how many working days are available in each month for the current financial year taking away any school/bank holidays.
As the month of August has zero days available it has excluded this month from the view.
As the total number of days available will always be zero for the month of August, then it seems acceptable to hardcode the SQL to always have 0 for August, and also an April-August record which will be the same as April-July.
What would be the best way to add these 2 records, and where about in the code should it be placed see example of code layout:
see link (answered question) for layout of code:
SQL populate total working days per month minus bank holidays for current financial year
