Display month wise data

• deepusurana

  SSC Enthusiast

  Points: 144

  More actions

  December 20, 2007 at 1:41 am

  #70614

  Hi,

  I am accpting date from the user in a form.

  And i want to display the data in crystal reports month wise, in which i want the month names to be the column.

  Ex:

  Is there any way by which i can achive this output by sql query...?:confused:

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  December 20, 2007 at 1:50 am

  #761673

  Use datename function

  For Example if you want to get current month

  select datename(mm,getdate())

• Gogula G. Aryalingam

  SSCrazy

  Points: 2688

  More actions

  December 20, 2007 at 2:14 am

  #761675

  http://www.sqlservercentral.com/Forums/Topic435101-149-1.aspx?Update=1