In other words, Dragon3486... messy code is hard to troubleshoot. 95% of all such simple syntactical problems can easily be avoided altogether if you format your code in an...

More likely, since you said you had the window open for days, the data in the tables the view references changed. Doesn't take a lot... if your execution plan...

And, the "re-used" execution plan for 1 set of parameters might be absolutely terrible with another set or sometimes a thing called "parameter sniffing" kicks in and the whole server...

If, what you really mean, is that you don't want anyone to be able to "steal" your code, then you must check all of your code into some safe place...

The others are correct... We can't write a script for your tables because you haven't posted them or any sample data....

Both are nothing more than "in-line" views... views can use indexes just like any query can. Same goes for CTE's and Derived tables... "Have Index, Will Compute". 😀

I've had a great many similar experiences especially with poor performance due to Table Variable usage. If you add in the fact that TempTables persist in Query Analyzer whereas...

If you really want technical... scroll back up to the early stages of this thread and look at the URL I recommended... :hehe:

If the underlying tables are correctly indexed, the CTE...

But I want my Easter Eggs NOW!!! Where's my porkchops? 😛

Tao Klerks (3/18/2008)

---

Thanks GSquared - this makes sense to me.

I don't think I agree about the clarity of using CTEs for derived tables, but I guess that might be...

To me, CTE's have the advantage of Derived Tables because you can reference them many times in the same query at different levels in the query whereas a Derived table...

Gosh... ya gotta wonder, though... seems like the VarDecimal datatype option has a pretty limited application... you'd think they'd have spent more time on something important like getting SUM() OVER()...

Sorry Gus... I actually didn't mean it that way (better)... I just meant it's different and you don't need the CTE if you don't want it. They both run...

Matt Miller (3/18/2008)

---

Wow - I didn't even read the question correctly. Thanks Jeff for the wake-up there (pinging the caffeine IV).

I just came across this -

http://weblogs.sqlteam.com/mladenp/archive/2006/11/10/19546.aspx

It does seem...