Wow awesome info.

Just out of curiosity. Are you comming from oltp or olap for this conclusion?

I understand phase 3 is expansive, but if it saves my butt from a...

GilaMonster (7/12/2011)

---

That's not a warning. It's saying that the optimiser stopped because it had found a...

Whack the view and the min / max. That'll give you all the runs and return the data you need.

If this is not what you want then please post...

Cursor query :

Good Enough Plan Found (not awefull but better if you don't have this warning)

estimate 4 vs 354 found (can be a real big problem if you have...

Why don't you post the code you currently have and ask...

Nope that's sql 2005.

use the working format or change the parameter datatype. Nothing else you can do about this.

Best practice would also tell you to set and explicit DATEFORMAT (IE :...

Ya this is a bad idea to use strings instead of dates... 1 of the very reasons you just found about.

I don't know what else to tell you. Works fine on my 2008 R2 Machine.

The only thing I can think of is that you are trying to run this...

That's not how I handle this.

I have a calendar table. In that table I also include holidays.

Then I add a calculated column

CASE WHEN WeekDay BETWEEN 1 and 5 AND...

It works on my system (express 2008 R2). What error are you getting?

What version of sql server are you running this on?

Works fine here.

What's the error?

Can you post the full script?

Looks fine. Try compiling all the code that comes before that line.

adams.squared (7/11/2011)

---

Well I've been using both SP and queries. Probably 70/30 queries to SP. The more complex it is, the more likely I am to use a SP...