The datatype of the date field in the FB table is smalldatetime, same as the parameter variables.

I compared execution plans this morning & yes, the query takes entirely differnt path...

The query & table def are pretty huge, a bit much for a help forum.

I've got around the problem by loading the required rows of the FB table into a...