how to check the previous records and after records

I am not able to clearly understand the question, a sample data (insert script would be great) and expected results would help us understand the requirement easily

and what is the SQL Version you are using ?

---

Satheesh

My Blog