I have been given the assignment to write an app against a given database.
The problem is that the database structure violates first normal form.
The "designer" set up a table as follows:
Table Name: Project Detail
The "day o' week" attributes are to hold the time worked.
For those of you that don't recognize it - the "designer" has set up an
array in a relational database.
I have been told that the structure of the table CANNOT CHANGE.
My unfortunate task is to build a function to return the number of hours
worked between two supplied dates. For example, I have return number of
hours worked between Wed, March 31 and Wed, April 7.
BTW Week_ending dates are always a Saturday date.