Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 05, 2012 07:38 AM by oned_gk
0 Points
1 Post
Nov 05, 2012 05:57 AM|LINK
select datename(month,regisdate)+' '+datename(yyyy,regisdate) as 'Month',count(*) as 'Noofuserregistered' from userdata
group by datename(month,regisdate)+' '+datename(yyyy,regisdate)
order by case datename(month,regisdate)+' '+datename(yyyy,regisdate)
WHEN 'January 2012' THEN 1
WHEN 'February 2012' THEN 2
WHEN 'March 2012' THEN 3
WHEN 'April 2012' THEN 4
WHEN 'May 2012' THEN 5
WHEN 'June 2012' THEN 6
WHEN 'July 2012' THEN 7
WHEN 'August 2012' THEN 8
WHEN 'September 2012' THEN 9
WHEN 'October 2012' THEN 10
WHEN 'November 2012' THEN 11
WHEN 'December 2012' THEN 12
End
All-Star
31267 Points
6394 Posts
Nov 05, 2012 07:38 AM|LINK
select datename(month,regisdate)+' '+datename(yyyy,regisdate) as 'Month',count(*) as 'Noofuserregistered' from userdata group by Month(regisdate) order by Month(regisdate)
sourabh_.net
0 Points
1 Post
guys i am sharing a query i tried to get no of employees registered in any month of year...
Nov 05, 2012 05:57 AM|LINK
select datename(month,regisdate)+' '+datename(yyyy,regisdate) as 'Month',count(*) as 'Noofuserregistered' from userdata
group by datename(month,regisdate)+' '+datename(yyyy,regisdate)
order by case datename(month,regisdate)+' '+datename(yyyy,regisdate)
WHEN 'January 2012' THEN 1
WHEN 'February 2012' THEN 2
WHEN 'March 2012' THEN 3
WHEN 'April 2012' THEN 4
WHEN 'May 2012' THEN 5
WHEN 'June 2012' THEN 6
WHEN 'July 2012' THEN 7
WHEN 'August 2012' THEN 8
WHEN 'September 2012' THEN 9
WHEN 'October 2012' THEN 10
WHEN 'November 2012' THEN 11
WHEN 'December 2012' THEN 12
End
oned_gk
All-Star
31267 Points
6394 Posts
Re: guys i am sharing a query i tried to get no of employees registered in any month of year...
Nov 05, 2012 07:38 AM|LINK