Another option:

SELECT pd.CustID

FROM Product_Details pd

LEFT JOIN (SELECT CustID FROM Product_Details WHERE ProdID = 0) c ON pd.CustID = c.CustID

WHERE pd.ProdID IN (1, 4)

AND c.CustID IS NULL

GROUP BY pd.CustID

HAVING COUNT(*) =...

This is SO cool!! Someone from this distinguished community simply MUST end up in the 15 finalists!!!

I have 36,465 records in my table and 21,776 will be removed. And this is a one time thing, that's for sure. I'm going to fix my insert...

Beautiful! Thank you very much Jason!

DISCLAIMER: Before I get too much egg on my face, let me say that a) I am cringing as I click "Post Reply" b) it's actually been so long...

GSquared:

I checked the Addresses table and it covers United States and Canada so it is a large area. As far as accuracy, I have asked what the tolerance should...

VERY helpful information Dixie Flatline. Are you suggesting using geometry instead of geography, or ditching both, period? Understanding testing is definitely needed. We are just expecting that...

Thank you for your reply. I've just started testing how to work with our data, simply to get the concepts down. I think I've definitely settled on storing...

Ewww.... yeah, I'll agree with you on this one....

Oh man! That's MUCH cleaner than where I was going! I was capturing the min and max rows (using row_number()) where hours were entered. Then capturing rows...

Thank you very much for the reply Andrew. Turns out we had a consult session with Microsoft last week here are some items from my notes:

- EF may not...

Very good point: "So I would be looking for clarification of the requirements, and making it clear that there is a performance issue, if they want to search the...

roger.plowman (8/31/2010)

---

I'd think (from a performance standpoint) using LIKE is the *last* thing you'd ever want to do. Especially the "Like %X%" construction, since at best it's going to do...

I have to join in as well. This community is priceless. This is the first place I look when I need to find a solution to a problem....

Bravo! I love (and learn best from) step by step instructional articles like this. I've created some SSRS reports but it is not something I do often so...