If you want a reference to a HoH:

my $href = $dbh->selectall_hashref(<<SQL, 's_week');
select s_week,s_month,s_workperiod from <tablename>
SQL
[download]