title: SQL Server Trigger - Insert the deleted record into another table with deletetime
body: <p>Currently I have a Item table and a ItemWaste table. 
  Both tables will have some fields, such as: Name, Amount, etc. But the ItemWaste table will have one more field, which is the TimeWasted.
  I wish to automatically insert the DELETED item from the Item table to the ItemWaste table, and at the same time insert the deletion time to the TimeWasted field.</p>
  
  <p>I got no idea how to do this, is it using trigger???</p>
  
  <p>Hope can get some help here... Appreciate any feedback... Thanks....</p>