_______________________________________________________________Need help? data types are capable of holding extremely large amounts of data, up to 2 GB, in a single value.TOP ( ) Specifies one or more table hints that are allowed for a target table. @ When referencing the Unicode character data types nchar, nvarchar, and ntext, 'expression' should be prefixed with the capital letter ' N'.If ' N' is not specified, SQL Server converts the string to the code page that corresponds to the default collation of the database or column.I also noticed you cast the physical location as varchar and given that the data looks like network locations there is really no need to support unicode. Read the article at Practices/61537/ for best practices on asking questions. I join the table to itself to limit the amount of rows it tries to update.
DEFAULT Specifies that the default value defined for the column is to replace the existing value in the column. Do the updated fields have the 'ly' changed to 'ts' after the update?This update should do the same thing unless there are details removed for the sake of posting that would be used in the string concatenation and joins.The conditions for storing the BLOB strings in the row still apply though: There must be enough space in the data row to hold the pointers.For more information, see strings are stored outside a data row; only the text pointers to these strings reside in the data rows.