Yesterday I make some mistake on accidentally update the data in the table. But lucky we have a daily backup of database in our server. So try to restore back the backup to a new database and the do a cross database and cross table update to recover back the latest possible data.
Try to google and MSN with some of my experience friend and found out this, just to upload to here in case may need it again in the future. *hopefully will not use it again la...
Cross table update
SET ytd_sales = t.ytd_sales + s.qty
FROM titles t, sales s
WHERE t.title_id = s.title_id
AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)
Cross database query
from dbo.ThisTable t1
join ThatDatabase.dbo.ThatTable t2
on t1.KeyColumn = t2.KeyColumn