Your problems come from the wrong table design. You need to store start date and end date as dates in 2 separate columns. Once you correct the bad design of that table, all queries will become much simpler to create.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles
No comments:
Post a Comment