Les Cardwell (3/15/2010)

---

Interestingly enough, the biggest cost to the initial query, which probably exceeded benefits of denormalization, was using a 'function' in a WHERE predicate...

WHERE P_MS.DateReceived > getdate() - 365

...would...

Gilles Willard (3/15/2010)

---

It seems to me that what Timothy is proposing is simply adding a few FKs to his database design to cut down on the JOINs required to get...

FYI: This article explains both methods. Hope this helps...

http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx

The best one that I can think of in SSIS is the "Lookup" task in the "Data Flow Transformation" section within the "Data Flow Task". It's not as straight...