Hello i have a table with two columns, ID and Date. There needs to be 24 rows of the same date (1 row per hour) for every day of the current month. My query will need to see if there are any missing intervals. For example, find where there are <24 rows for every day of the current month. This is how my table looks for ex:
ID Date
123 5/29/2012
123 5/29/2012
456 5/30/2012
456 5/30/2012
^There should be 24 rows of each ID for that particular day, so ID 123 should appear 24 times for 5/29/2012. If it is less than that, then it should appear on the query. Thanks so much!