OpenLightGroup Blog

rss

Blogs from OpenLightGroup.net


Daily Growth Of LightSwitchHelpWebsite.com Still Accelerating

I ran this query that shows the user registrations by day:

 

select qty AS UserCount, substring(mo,charindex(mo,'/'),50) as date
from (select mo=convert(varchar(2),month(CreatedOnDate)) + '/' + convert(varchar(4),day(CreatedOnDate)) + '/' + convert(varchar(4), year(CreatedOnDate)) 
,qty=count(convert(varchar(2),month(CreatedOnDate)) + '/' + convert(varchar(4),day(CreatedOnDate)) + '/' + convert(varchar(4), year(CreatedOnDate)))
from Users group by convert(varchar(2),month(CreatedOnDate)) + '/' + convert(varchar(4),day(CreatedOnDate)) + '/' + convert(varchar(4), year(CreatedOnDate))) a

To produce:

  User Count
8/20/2010 2
8/21/2010 1
8/27/2010 1
9/7/2010 1
9/10/2010 1
9/13/2010 1
9/17/2010 1
9/19/2010 1
9/23/2010 2
9/24/2010 1
9/25/2010 1
9/28/2010 1
10/6/2010 4
10/7/2010 1
10/12/2010 2
10/20/2010 1
10/21/2010 1
10/28/2010 1
10/31/2010 1
11/3/2010 1
11/9/2010 1
11/22/2010 1
12/12/2010 1
12/22/2010 1
1/11/2011 1
1/17/2011 1
1/24/2011 1
2/1/2011 1
2/9/2011 1
2/20/2011 1
2/24/2011 1
3/8/2011 1
3/22/2011 2
3/28/2011 1
3/29/2011 1
4/5/2011 2
4/8/2011 1
4/16/2011 6
4/17/2011 1
4/18/2011 4
4/19/2011 5
4/20/2011 2
4/21/2011 1
4/22/2011 1
4/23/2011 1
4/24/2011 1
4/25/2011 5
4/27/2011 1
4/29/2011 3
5/1/2011 3
5/2/2011 4
5/3/2011 3
5/4/2011 4
5/5/2011 3
5/6/2011 4
5/7/2011 2
5/8/2011 2
5/9/2011 2
5/10/2011 5
5/11/2011 4
5/12/2011 2
5/13/2011 7
5/14/2011 4
5/15/2011 6
5/16/2011 6
5/17/2011 6
5/18/2011 3
5/19/2011 4
5/20/2011 7
5/21/2011 2
5/22/2011 1
5/23/2011 8
5/24/2011 9
5/25/2011 4
5/26/2011 4
5/27/2011 4
5/28/2011 3
5/29/2011 2
5/30/2011 6
5/31/2011 4
6/1/2011 7
6/2/2011 14
6/3/2011 4
6/4/2011 7
6/5/2011 9
6/6/2011 13
6/7/2011 8




Comments are closed.