How to get the Year in between two dates

DECLARE @start DATETIME, @end DATETIME;

SELECT @start = '28-Dec-2015', @end = '05-Jan-2016';

select year(dt) [Year], count(*) [Numer_Of_Days]

from (select top(datediff(d, DATEADD(Day,-1, @start), @end)) dateadd(d, row_number() over (order by (select null)), DATEADD(Day,-1, @start)) dt

from sys.columns) q

group by year(dt)

order by [Year]

DECLARE @start DATETIME, @end DATETIME;

SELECT @start = '20121126', @end = '20130110';

CREATE tABLE #TEMPDate (id int identity(1,1),DateWise datetime)

insert into #TEMPDate(DateWise)

SELECT TOP (DATEDIFF(DAY, @start, @end)+1)

DATEADD(DAY, ROW_NUMBER() OVER (ORDER BY name)-1, @start)

FROM sys.all_columns

select COUNT(*),Year(DateWise) from #TEMPDate

group by Year(DateWise)

drop TABLE #TEMPDate