display month for each date

See more:

SQL-Server

i have leave table in sql.columns are

SELECT TOP 1000 [leaveid]
      ,[empcode]
      ,[Leave_type]
      ,[time]
      ,[From_date]
      ,[To_date]
      ,[No_of_days]
  FROM [company].[dbo].[leave]

if employee takes leave from-date=2014-01-01 00:00:00.000,to-date=2014-02-01 00:00:00.000

totally employee takes 32 days leave,in january month he takes 31 and february employee takes one day,total days=32,
i want to display month wise leave display

please help me

thanks in advance