''Complex'' statements to work out churn

• David Clothier

  SSC Eights!

  Points: 831

  More actions

  December 15, 2006 at 8:47 am

  #170776

  Hi. I have a need to create a report based on user *churn* on our system.

  I have a list of unique UID's for each month that I want this for - Dec 05 until now... What I need to figure out is the amount of unique users in Dec 05, then see how many of those are still active in Jan 06, Feb 06.. and so on...

  Also, all the new UID's in Jan 06, Feb 06 need to be calculated the same way for the months that follow until now...

  Does this make sense?

  Is it possible in SQL?

  Where on earth do I start?

  Thanks in advance,

  David

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  December 15, 2006 at 1:52 pm

  #678461

  with out a SQL statement I would think it should look something like this

  select UID FROM Tbl_UID WHERE

  UID IN (Select UID FROM tb_UID Where UID_Active = 1 and login_Date >= 1/1/2006)

  Also this is not a reporting question it is more T-SQL.  You will get more hits there