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, @dateFROM table1WHERE 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