Please refer this SQL Script
SQL
DECLARE @Leaves TABLE(
Leave_ID bigint IDENTITY(1,1)
,Leave_From datetime
,Leave_Upto datetime )
INSERT INTO @Leaves VALUES('2015-01-01','2015-01-02')
INSERT INTO @Leaves VALUES('2015-01-25','2015-01-27')
INSERT INTO @Leaves VALUES('2014-11-10','2014-11-15')
INSERT INTO @Leaves VALUES('2014-12-31','2015-01-03')
SELECT DATEDIFF(DAY,Leave_From,Leave_Upto) [DAYS]
,CAST(DATEPART(MONTH,Leave_From) AS VARCHAR(10)) + '/' + CAST(DATEPART(YEAR,Leave_From) AS VARCHAR(10)) + ' To ' +
CAST(DATEPART(MONTH,Leave_Upto) AS VARCHAR(10)) + '/' + CAST(DATEPART(YEAR,Leave_Upto) AS VARCHAR(10)) AS [FROM_To]
,DATEPART(YEAR,Leave_From) [Year]
FROM @Leaves
Output
DAYS FROM_To Year
1 1/2015 To 1/2015 2015
2 1/2015 To 1/2015 2015
5 11/2014 To 11/2014 2014
3 12/2014 To 1/2015 2014