Hi,
I'm using ms sqlserver 2000. I want to write a stored procedure and it must do following
1. Select certain records from a table using a where clause
2. compare two fields of two records (say F1 of row 1 with F2 of row2)
3. update another column (say F3 of row2)
4. Use a loop to continue these 2 & 3 steps

Please help me to do this. Any suggesion will be highly appreciated.