Thanks James. I'm keeping a copy of that article for when I have time to revisit the issue.

That definitely is an option in the SQLCLR project, but isn't a solution since it causes the whole assembly to be unloadable in SQL Server. The full error is...

As far as wrapping the 32-bit dll in a Windows Service, I'll have to pass on that for now. I have a deadline and have to cut the research...

Thanks to both of you for your assistance in this matter, but I believe I have found the cause of the failure with LoadLibrary.

I added a call to GetLastError and...

Targeting framework v.2 gets the same results.

opc.three: That must be the answer to someone else's question. I'm trying to dynamically load an old dll in SQLCLR (ie. use late binding by way of LoadLibrary).

That would be SQL Server 2008, targeting .Net Framework 3.0.

I've already been to both of those links, but neither one is quite what I need. The one using SQLCLR is using static loading of the dll, but, since...

The permission set has been set to UNSAFE. I don't think it will install otherwise.

It's not just a matter of checking licensing. If the file exists, I will need to actually call the calculation it contains as well.

If there's another way to dynamically...

I created 2 test tables, one with datetime columns and the other with int columns and populated them with 9.5 million rows from a copy of a client database. ...

I'm sure your test queries work much better, but they don't represent the essential element of my required query, which is that the given value is being compared against two...

By the way, the datetimes are really just dates.

Thanks for the ideas elutin. Unfortunately, since we allow our users to develop their own reports (as well as hundreds of reports developed by us) using Crystal Reports I'm...

Outrageous? I've always considered consistency to be a good thing. The same bad SQL run against the same data should always give you the same bad result.