)
AND NOT EXISTS
(
SELECT *
FROM load_cntl AS B
WHERE B.LOAD_DATE = DATEADD(A.LOAD_DATE, 1)
)
Good Luck!
Charlie [EMAIL PROTECTED]/Shield/Michigan
From: Mark Marshall Date: December 10 2003 6:01pm
Subject: SQL Statement Help - Is this possible?
I have a database table that has one
I have a database table that has one row entered every day by the user.
If the user skips a day, it throws off our monthly totals. Assume a
table with four columns:
id (which is the key), date (-mm-dd), data1 (int), data2 (int)
Is there a way to say Select the first missing date in the