You could try splitting it into 2 or more bits of sql and concatenating them at the end. Also try using nvarchar instead of varchar (I'm not sure why...

I think your sql is correct - the reason no rows are being returned is because there is no data that falls within the date range of your parameters.

If you...

I'll try that one out also, the first method is very slow on my large dataset.

Great, seems to do the trick.

Thanks for your help!

One quick and dirty method that I have used before is to copy all the data that you are updating from to a temporary table that has the correct collation...

The eventual solution to our problem was to code each of the different solver equations separately rather than try to find a generic solution.  I understand from the programmer who...

The logs shouldn't be a problem, we get less than 1 deadlock per week.  We've switched on the trace flags and are now waiting for a deadlock to occur.

Thanks for your help Carolyn!

--->The alternative is to write a query instead an "on the fly" ad hoc mess.<---

Whilst dynamic SQL is untidy, it is often necessary in the real world.  Think of report...

Final times were basically all the same at around the 300 seconds mark.  It would be nice if it were faster, but as this is for our own internal purposes,...

UNION ALL fixes the problem!  I hadn't appreciated the difference between UNION and UNION ALL. I knew I must be doing something...

Thanks for the link Chris, it looks interesting.  I'm hoping that that we may be able to pre-calculate the numbers that we need in a self-contained process rather than run them as...

Hi Chris,

I think you a right about the solver, from what I have gathered so far it does about a thousand iterations.  I've had it in the back of my...

Thanks for your comments, apologies again for not making my question clearer at the start.  If I find a pre-canned solution, I'll post it here.

Thanks Richard, I think you have hit the nail on the head.  I'm not really looking for coding samples or database design advice that might help us write a custom...