Try
declare @tbl Table(Leave_Approval_Id int, Leave_Start_Date DateTime, Leave_End_Date DateTime, EmpId int)
insert into @tbl
select 1, '2013-01-25 00:00:00.000','2013-02-10 00:00:00.000', 10
select DateDiff(Day, Leave_Start_Date, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))) from @tbl