Given the scenario a set based update will work as well and would be more efficient as the gentleman posted above. Would put something like this at the beginning...

I am currently developing a new system using SQL 2005. Some of the feature we are using include:

1. MAX datatypes. In SQL 2000 nvarchar had a max...

You can use a cursor to load up a set of rows and then perform an update on each one.

Example code for end of sproc:

-- Holder for row data

DECLARE @Holder...