How to Work On SP..?

Hi,
 i have a query in Stored Procedure..?

my condition. i am searching for a data in the table and if that field is not empty on the pervious date. thn i hve to insert the same data to another field with the current date. give me a clear tips for solving my issues..!!!