So, I have this query that yesterday is working fine and quick when I left outer join three tables. But when I change them over to inner joins takes forever...

Gianluca Sartori (12/16/2010)

---

Actually, dynamic SQL is the most efficient way to handle optional parameters in stored procedures.

Using COALESCE, ISNULL, CASE...

WayneS (12/15/2010)

---

CELKO (12/15/2010)

---

>> There's math problems with money? Please, do tell. I haven't heard anything about them and as I use that field [sic: columns are not fields] quite a...

CELKO (12/15/2010)

---

>> Now Microsoft may or may not have implemented COALESCE() by ANSI-Standards. I don't know. But given that no one can compare one unknown value (NULL) to another unknown...

Congrats, Tom. Remember to spoil her properly now.

WOTD: Spoil

Please start a new topic for your question.

I think I just found it. Money rounds funny when being used in division and multiplication.

Interesting that I never ran into this before. I should make a SQL Server question...

Not believing I'm actually going to get an answer to the question I posted on the thread Wayne just linked, I'm going to ask the question here.

Has anyone heard of...

CELKO (12/15/2010)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are.

Sample data is also...

There's math problems with money? Please, do tell. I haven't heard anything about them and...

Paul White NZ (12/15/2010)

---

On the other hand, IN and EXISTS have slightly different NULL-handling semantics, so it is not possible to express the exact same logic using IN as it...

If I'm...

We just got a Phoo place in Jax that I'm dying to try out.

I miss our Mongolian BBQ. Used to have one near our house that was out of this...

Well, the source database is already a day behind production. So I need to find out how often the cube will be reprocessed. Or, more accurately, how often the reports...

You're welcome.

There are a few other things I should mention.

Don't drink high amounts of caffeine before a presentation. It dries out your throat. Don't drink anything cold before a...