EchoAlertcom
IS-IT--Management
Hello,
I have to make a report that only pulls from 1 table. But I need several different ways of looking at the same data.
How do I run summaries of different counts from the same table?
Related columns include of dbo.Leads:
Phone, Signupdate
Here are 4 simple queries I need to join into one query, could someone get me started please?
I would like the recordset to resemble:
I am stuck and don't know where to start...
Thanks,
Steve
I have to make a report that only pulls from 1 table. But I need several different ways of looking at the same data.
How do I run summaries of different counts from the same table?
Related columns include of dbo.Leads:
Phone, Signupdate
Here are 4 simple queries I need to join into one query, could someone get me started please?
Code:
Select Count(*) as GrossLeadsCount, SignupDate From dbo.Leads Group By SignupDate
Select Count(*) as UniqueLeadCount, SignupDate From dbo.Leads Where UniqueLead = 1 Group By SignupDate
Select Count(*) as ONetMatchCount, SignupDate From dbo.Leads Where OnetMatch = 1 Group By SignupDate
Select Count(*) as UniqueONetCount, SignupDate From dbo.Leads Where UniqueLead = 1 And ONetMatch = 1 Group By SignupDate
I would like the recordset to resemble:
Code:
Date: Gross: Unique: ONetMatch: UniqueONet:
08-13-06 399 201 150 134
08-14-06 543 324 175 142
I am stuck and don't know where to start...
Thanks,
Steve