Bill Talada (1/31/2013)

---

If I purchase an application, I can use it any way I want to. I used to be an academic purist back when I first started in...

Ron, you must have overlooked something this time.

Can you please supply DDL for tblConsul and #tmpPlan, including all indexes.

While you are there, can you supply the view definition.

souLTower (1/25/2013)

---

I've run this test previously with similar results. I've attached the execution plan. I removed some columns so that we're just dealing with the view in question.

Thanks!...

Can you tell me how the following two queries compare please.

PLEASE NOTE: You have not aliased all your columns so I have no idea which tables they come from. You...

My impression is that your query is too complicated and the query optimizer has no chance of compiling the most efficient plan. You can see this in the execution plan...

If your desired output above is 2013-01-24 then my first solution is correct.

If your desired output above is 2013-02-15 then the following will work.

SELECT

TOP 1 *

FROM

#mydates

ORDER BY

CASE

WHEN mydate >...

Just to add, I simplified your requirements.

To put it in words, if greatest mydate is less then current date, select most recent mydate. Otherwise if mydate is greater or equal...

SELECTTOP 1 *

FROM#mydates

ORDER BY ABS(DATEDIFF(SECOND, GETDATE(), mydate))

GilaMonster (1/24/2013)

---

Very likely has nothing whatsoever to do with the execution plan. 15 seconds is far longer than SQL takes to compile anything other than a ridiculously complex query.

Restarting cleared...

I agree with that sentiment, however I learned...

Just my Friday attempt at some humour.

Hi,

I read the article you referred to at http://www.sqldbadiaries.com/2010/12/13/change-service-account-password-the-specified-network-password-is-not-correct/.

Can you confirm you selected "Entire Directory" for the location field as mentioned at the bottom of the article.

The From this location...

I have downloaded the plans and they are exactly the same. I downloaded them twice in case of PEBKAC issues.

What datatype are you using for DCPI_Date in Reliance_Master and Ram_Reliance_Master?