i'm trying to find uncommon records within a date range. i'm somewhat successful, but i only get records for the first date of my criteria not the rest of them.
this is what i wrote :
SELECT item1, @date
WHERE item1 NOT IN
WHERE Date >= CONVERT(datetime, @Date) AND
Date <= DATEADD(DAY, 2, CONVERT(datetime, @Date)))
as i said, i only get the first day's record, but not the other days in the range.
can anyone help me? i'm using sql 7