Calendar table workaround

[Jonathan Mangin]

I created a calendar table (date only), but all
where clauses include a uid.  Is the following a
sane workaround to get a usable calendar table?
Anything else I can do?

my $sth = $dbh->prepare("
create table $temp_tbl
(date date,
uid varchar(14))
select date,
? as uid
from calendar
where date between ? and ?");
$sth->execute($uid, $bdate, $edate);

Thanks.