select top 1 sum((NoofDayPresent+ELtaken+CLTaken+Holiday +PaidLeave)) from AttendenceMonthWise where EmployeeID=2 and MonthID in(4,5,6,7,8,9,10,11,12) and YearID=2019
and MonthID in (select MonthID=1,2,3 from AttendenceMonthWise where YearID=2020)
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Nirav GandhiPosted May 24, 2019, 10:57 AM
Arkadeep DePosted May 20, 2019, 9:36 AM