Hello, I'm querying a table where a lot of dates are stored per row. Each record can have up to 15 nullable dates i.e. productid, dateA, dateB, dateC.....dateO This leaves me wondering how best to query this in the most performant way - I need to be able to query on a date range - between @dateLow and @dateHigh. The only thing is, with so many date columns per row, it seems a bit cumbersom on poor ol sql server to have to use an OR pedicate to do something like: where dateA between @dateLow and @dateHigh OR dateB between @dateLow and @dateHigh and.....etc etc I'm assuming that to check through 15 nullable columns in this manner for each record is not pretty. Is there a more efficient way to do this in terms of actual t-sql, or is my only hope of optimization a covering index or something?