I have a table that contains patient visit data for a number of patients.
The important column is the VisitDate column.
I need to now produce a crosstab showing the total counts of patient visits on a daily basis.
In the cross tab i need to include the dates where there are no visits. So basically 30(31) columns for a months data.
I think that i need to create a table with the possible dates and then somehow join them with the table PatientVisits using the VisitDate column.