Help with Counts

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 20, 2012 at 6:14 am

  #1436424

  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