but jason I alsio need to updateed parentprocedureID of procedureId 86 as 86 only----
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/