I have a table called Documents that holds a number of documents. There are couple of columns that are interesting to me.
The first is doc_Datetime that holds the datetime that the document was added.
The second is the doc_Exported (bit) that tells me the document has been exported.
I need help with a query that will show the total number of documents recieved each day, and the number of them that have been exported.
The result set should even include days when no records have been received.
Date Documents received Documents exported.
2012-03-18 123 80
2012-03-19 10 9
2012-03-20 0 0
2012-03-21 12 11