Nothing makes me want to pull my hair out more than writing SQL Queries that need to join two or more tables, with one of those tables containing an "Effective Date" column. Of course, the requirement is inevitably to filter out all records from this join such that the match condition is on some date value from one table and the latest "Effective Date" from the second table that pre-dates the first table's date value. /headdesk
For example, suppose that we have a table that maintains a "capacity" number that changes over time. To maintain historical accuracy, an "Effective Date" column...
The second annual CodeMash Conference will be held on January 9-11 at the Kalahari Resort (indoor waterpark!) in Sandusky Ohio.
Session List: http://codemash.org/SessionList.aspx
Keynotes: Scott Hanselman, Brian Goetz, and one more in the works!
Register today! An incredible rate on the hotel room/waterpark access for $88/night is only guaranteed for a few more weeks.
https://www.codemash.org/register.aspx