I doubt whatever server SSC is using could hold a complete list of everyone who has ever deserved one of Jeff's porkchops! There just plain isn't that much disk...

Your case statement appears to do what you say you want. What problem are you running into?

noeld (1/16/2009)

---

There are *many* things Oracle can do that SQL Server can't. So much so, that Oracle is normally being refused because of its too many knobs....

Now that being said...

Calendar table, definitely.

For second best, something like this should do:

;with

Numbers (Number) as

(select top 7 row_number() over (order by object_id)

from sys.all_objects)

Week (Date) as

...

I'm not at all clear on what you're asking for.

Update, and if @@Rowcount = 0, then insert. That's more efficient.

The difference is that, if it's an update, you only access the data once that way, but twice if...

An interesting addendum to this article would be data on the proper and improper use of Cross/Outer Apply. That, by definition, is pretty much a guaranteed triangle join, but...

I think that if a company started out that way, and stayed that way, regardless of size, it would be fine. There would have to be clear and definite...

I just tried your test case, and it returned all rows. That seems to be the opposite of what you posted. What am I reading incorrectly?

Garadin (1/15/2009)

---

Isn't the point of that whole debate that the optimizer can do what it wants? While the test code may demonstrate certain characteristics, is anyone certain that another...

I'm assuming that you mean that users lost their rights to execute procs. That can happen from a number of things. Someone may have been adding permissions to...

ScottPletcher (1/15/2009)

---

Again, this code does work:

select isdate(col1), *

from #t

where isdate(col1) = 0

or datepart(year, col1) = 2001 --sql treats yr "1" as "2001"

SQL will definitely short circuit when it knows...

I'm not clear on what you just wrote. Sorry, just can't understand it. Maybe someone else can.

Yep. That's why I said, "I think".

It depends on a number of things.

Is the database in full recovery mode, and do you have a product that can parse the transaction log?

or

Do you have any sort of...