guys i am sharing a query i tried to get no of employees registered in any month of year... RSS

• • Reply
  

  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

  • Edited by sourabh_.net on Nov 05, 2012 05:58 AM
  • Edited by sourabh_.net on Nov 05, 2012 05:58 AM
  • Edited by sourabh_.net on Nov 05, 2012 05:58 AM
  • Edited by sourabh_.net on Nov 05, 2012 05:58 AM
  • Edited by sourabh_.net on Nov 05, 2012 05:58 AM
  • Moved by Mikesdotnetting on Nov 05, 2012 06:22 AM
• • Reply
  

  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

  select datename(month,regisdate)+' '+datename(yyyy,regisdate) as 'Month',count(*)
  as 'Noofuserregistered' from userdata
  
  group by Month(regisdate)
  
  order by Month(regisdate)

  Programming to simplify, dont look for hard way