David Rueter (3/29/2012)

---

Thanks, Jeff.

I thought my standard pattern of simple joins would do about as well:

SELECT DISTINCT p.CustomerID

FROM

#Purchase p

JOIN #Purchase p2 ON

p.CustomerID...

Interesting conversation.

Here in my company I have a friend who told me that one of the most experienced DBAs (+10 years) failed the SQL Server 2008 certification on implementation &...

I see that most examples are accessing the same table more than once (IN/NOT IN, EXISTS/NOT EXISTS or JOINs). I wonder if it's faster than acessing the table only once...

I guess I may have drank too much coffee today. :doze:

Thank you.

SELECT

CustomerId

FROM Purchase

WHERE ProductCode IN ('A','B', 'C')

GROUP BY CustomerID

having sum(case when ProductCode = 'A' then 1 else 0 end) > 0

and sum(case when ProductCode =...

I guess what Jeff means is this:

SELECT emp_id,

course1,

course2,

course3,

...

Just to add to what the others have said, I'm assuming that "EID" is the employer's ID and "DeptID" is the department's ID. If I'm right, this part of the...

The only two cases when I use "SELECT *" are:

1) Quick ad-hoc queries that will be used only once;

2) On the outer query when the inner queries already defined the...

Learned something new today. Thank you!

PaulB-TheOneAndOnly (3/26/2012)

---

Probably you are not looking at the right places, there is a vibrant community indeed - one entry point would be http://www.oracle.com/technetwork/index.html - the famous Oracle Technology Network. ...

Another great article! And it explains the reasons to use that technique going back to basics.

Sometimes we know that we should do things one way or another because it's recommended...

I'd really love to hear someone's opinions on why the Oracle community is somewhat difficult to find. Very different from the SQL Server community which has important events like the...

Jeff Moden (3/24/2012)

---

The thing I'm curious about is do you really intend to report by day? I can see storing weeks and months and their running totals but I'm...

Excellent advice. Actually we came with something similar while we we were on a meeting in the company.

Let me see if I understand what you suggested. A table with running...

Lynn Pettis (3/21/2012)

---

I'd say it depends on how the CASE function is being used. In this case it is being used on the right side of the equality condition...