Query to select records for all the dates in a given month
513813May 19 2006 — edited May 19 2006Hi,
I have a table that has date and value columns. The value is not available for all the days.
I want to write a query that will give the status of the data availability for all the days in a given month.
I will pass the Month-Year as the input to the query and output should give the Data available status(1 if data is available and 0 if data is not available) for all the days in that month.
For example;
If I pass Jan-2006 as input to the query then my output should have all the dates for Jan-2006 and the status (which will be 1 if the data for that day is available in the table or else it should be 0)
can anybody suggest me on how can i implement this