while (my $rows = $dbh->do(<<SQL)) {
update #LAG
set tmpDate = dateadd( day, case
                when datepart( weekday, cl.tmpDate) = 2 then -3 else -1 end, cl.tmpDate)
from #LAG cl,
        $db..HOLIDAY h
where cl.tmpDate = h.Date
and cl.country = h.country
SQL
        print "$rows holidays adjusted\n";
}