Hi all,
I have a table contains daily log information. I need to find out if any rows missing out in a given date range.
Is it possible to find out in a single select statement?
Scenario:
FileDate ID
----- ------
10/May/2007 3
12/May/2007 3
13/May/2007 3
So I want to display the row as "File Not Existing" for 11/May/2007
How can I do this?
Thanks.