looping through the records without using cursor???

[mrpro]

hi experts,
can any one give me a thought how can we write a stored procedure which loops through the records.
the basic purpose i need this query is to update each record with a new value by looping the records..

thanks for any help

 

[ESquared]

You don't need a loop to update dates if they are on the weekend. Just use a CASE clause in your update statement.