# compute the dates into array @dates
#execute stored procedure
my $sp = $msdbh->prepare(qq|usp_Dashboard_CallType \@start = ?|);

foreach my $cur_date(@dates) {
    $sp->execute($cur_date) or die("$sp->errstr");
}