And what are the differences ?


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Should have said this before.

Having had a quick view of the code I do not think you need a cursor at all.

If you want to substitute a value for when your field is null then use ISNULL(). If you want to set a value based on the current
value then use CASE. Like I said I cannot initially see the need for a cursor.




--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org