I have a table that the important parts look something like:
What I want to do is a query that gets me every day of the year and just has null values
for the days that don't have anything in the amount column. Is something like that
possible with sql? In fact, what I would really like is:
select month(entryDate) as monthPart, day(entryDate) as dayPart, amount
order by dayPart, monthPart
just with the whole year filled in. it will make my later code simplier if I can not have
to test for values as much.