UPDATE varchar(max) column using INNER JOIN with SQL2005

microsoft.public.sqlserver.programming

20 Dec 2006 5:37 PM

jesse.gavin

I have a tabled named bvc_Product and it has a parent-child
relationship. I need to update the LongDescription column on all the
Child records with the LongDescription of the Parent record. So I tried
the following:

NOTE: LongDescription is of the type nvarchar(max)
=================================================
UPDATE child SET
    child.LongDescription = parent.LongDescription
FROM
    bvc_Product parent INNER JOIN bvc_Product child ON parent.bvin =
child.ParentID
WHERE
    parent.SKU = 'ELW11060005'
=================================================

This does not work. However, if I try to update a different column (of
type nvarchar(50)) it works just fine.

Is there something special about nvarchar(max) that will not allow this?