hi,
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
FROM table1
WHERE item1 NOT IN
(
SELECT item
FROM table2
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
Uncommon record within a date range
Posted - 01/31/2013 : 17:10:12
