Chris,

OK. I have to give a bit more info while trying to keep the complexity from exploding. Essentially, what I'm looking for can be expressed against ColdCase's DDL with...

DECLARE @Quantity_Limit...

So, I tried adding a Constant, but no tuples are returned...

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

CREATE TABLE #Temp

(

iD ...

CC - the problem is that they don't have a common ID to group on, which is why I was struggling with the HAVING clause. I've considered adding a 'constant'...

>>Are you looking for ANY combination of Items where the quantity = 10 (or whatever number), or per-item?

Any combination of Items.

>>Also, would you consider it valid, if looking for...

So, in debugging a report to find a needle in a haystack last week, I was reminded of this topic/thread. One of the LOB apps our PUD uses tracks Utility...

Jack Corbett (3/24/2010)

---

Les Cardwell (3/24/2010)

If you are doing a platform agnostic cert then Celko would work, but for a SQL Server specific cert, then he might not be the best...

Steve Jones - Editor (3/24/2010)

I'd like to see this start going, though I think we need a forum, and a long debate on the PASS site. We probably also need...

I got tired of the Certification merry-go-round back in the early 2000's (which can become insane and a significant $ drain) and decided in stead to spend my $ on...

Thx Lynn... good to know. Still, alligators and all that... :unsure:

Actually, this:

WHERE P_MS.DateReceived > getdate() - 365

can use an index on DateReceived. The function call is on the right of the conditional and will only be calculated...

For what it's worth, it doesn't work in 2005 either.

Cannot...

In spite of the criticism, it was still a simple example of minimal denormalization to achieve an end result rather than a full-on explosion of wide rows to reduce the...

Well, initially music on my...

RalphWilson (3/2/2010)

---

Actually, A PK (or Primary Key) is the primary means within the database for identifying the row in question. Its main use is in PK-FK linkages or in...

RalphWilson (3/2/2010)

---

Excuse me but what DBMS allows you to create a P that is NO unique and why are you using it?

In most DBS's that I have used, a PK,...