You posted in 2 different forums for 2 different versions, please define which one would you like to consider. The other post is this one: http://www.sqlservercentral.com/Forums/Topic1551279-65-1.aspx

Your code seems to do something as simple as this:

Update dbo.tblname Set

rec_num = 0

If it doesn't satisfy your requirements, check the code you posted.