Canada.

Happy to help.

See how easy it is when you can run the code as posted? That's why we ask for sample data and it takes only 2 minutes to...

Trying to send the correct code again.

SELECT

*

FROM

dbo.Calendar

WHERE

dt >= DATEADD(D , 0 , DATEDIFF(D , 0 , GETDATE()))

...

It's just a table I have on my system with all dates. that way I can send tested code.

For some reason the >= and <= signs don't show up...

Not much.

SELECT * FROM dbo.Calendar WHERE dt >= DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) AND dt < DATEADD(MM, 3, GETDATE())

Again STOP cross posting.

Nevermind that part, I had missed the fact that there's 1 row per date where there's action on...

I think you missed a typo in your post

AND MG_VSLVOY_SCHEDULE.ARRIVAL_SCHEDULE_DT >= dateadd(mm, -3, getdate())

No more replies here please, continue the discussion here : http://www.sqlservercentral.com/Forums/Topic1153351-149-1.aspx

You think we'll help more here than on the other thread.???

HELP US HELP YOU.

Go sample backup code for that option? Never tried to make it work that way :ermm:.

Yes they could.

I've seen a simple 3 left join query kill a decent server on sql 7 by filling up temp db.

The base tables had less than 0.001% of...

GilaMonster (8/3/2011)

---

Ninja's_RGR'us (8/3/2011)

---

My first impression was that the stats would containt info that each key would only have 1 value... hence still having really great estimates. But now that...

Change transactionality to ???

GSquared (8/3/2011)

---

I think the Quote button works by inverted position on the page, not by ID.

You can use it easily on an earlier page than the most recent one without...

http://standalonesqlagent.codeplex.com/

No need to add any pressure, I think he feels it...

SQLkiwi (8/2/2011)

---

Well technically it's not the statistics...