Skip to Content
0
Former Member
Jul 18, 2008 at 03:09 PM

SQL2005 update problem

18 Views

I have an SQL update statement that I need to run in order to populate a udf. THis is a one time update that I first tested in SQL2000, where it worked correctly. In SQL2005 it does not work. The code is:

UPDATE inv1

SET U_subdesc = ''

FROM inv1 T0 INNER JOIN

OITM t1 ON t0.itemcode = t1.itemcode

WHERE t1.itmsgrpcod <> 106

It is designed to simply blank the text in the udf for items not in the items group 106. In SQL2005, this statement blanks all the udf records. The only clue i have is that the field type changes from nvarchar in SQL2000 to nvarchar(MAX) in SQL2005. How would this statement get formatted in SQL2005 to operate correctly?

Thanks