I have this temporary table that I dump records into that meet specific conditions, and I pull them from another table. I take them from my main table, and put them into my temp table, the records are all within a week of the date that the user selects. The problem I have is that when the records are copied into the temp table, the records in the main table that are marked for deletion are copied as well. Is there any way to stop this from happening?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copying records from one table to another
- Thread starter Samalia
- Start date
Mike Gagnon
Programmer
Try using SET DELETED ON, which will prevent you from copying the deleted records.
Mike Gagnon
If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)
- Status
Similar threads
- Locked
- Question