Hi I have a scenario that I am not sure how to write the query for.
Here is the scenario - have an employee record with multi value for project,
started date, end date.
looks something like
John Smith web site bug fix 2010-01-01 2010-01-03
unit testing 2010-01-04
2010-01-06
QA support 2010-01-07
2010-01-12
implementation 2010-01-13
2010-01-22
I want to find what project John Smith was working on 2010-01-05
Is this possible or I have to back to my database ?
Thanks
