March 26, 2008 at 12:52 am
Hi,
My suggestion would be to use an INSTEAD OF DELETE trigger. Write it in such a way, that it updates the record instead of deleting the record. And when it comes to retireving the data just you a simple SELECT statement with the WHERE clause to get only the required records.
Regards
March 26, 2008 at 3:56 am
Just update the darn flag to 1 regardless.
If it's a 0 then it becomes 1.
If it's a 1 then it's still a 1.
No need to be fancy with triggers and stuff, it only complicates it.
/Kenneth
March 26, 2008 at 4:06 am
Also asked and answered here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99666
N 56°04'39.16"
E 12°55'05.25"
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply