January 20, 2012 at 6:14 am
Hello. 🙂
Okay, given the use-case data, and that definition for datakey, I think the query I wrote with the Union All statements will accomplish what the business needs. Check with your salespeople, see if it does work for them business-wise. It will give a count of unique households and unique landlines to those households. Unless there are legal or other regulatory limitations on how it has to be counted, this should do what's needed.
Which raises the question, is it actually any faster than the current query on the real data? If not, it's not actually improving anything for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing post 121 (of 120 total)
You must be logged in to reply to this topic. Login to reply