create table #holiday_list (hol_date date, hol_desc varchar(100))
insert into #holiday_list
values('12/25/2015', 'Christmasc Day')
declare @Actual_Leave_To date, @Next_Day date
set @Actual_Leave_To='12/24/2015'
set @Next_Day=dateadd(d,1,@Actual_Leave_To)
while(select count(1) from #holiday_list where hol_date = @Next_Day)>0
begin
set @Next_Day = DATEADD(d,1,@Next_Day)
end
select @Next_Day
drop table #holiday_list