title: Stored Procedure (process data then insert into another table)
body: <p>What i wana do is actually process some data then insert the processed data into a new table..
  but first i need to check the target table ;if empty then delete everything in the table then only insert the fresh processed data..</p>
  
  <p>i'm using sql server 2008...</p>
  
  <p>anyone can give me the sample sql code to create the stored procedure??</p>