Copying NTEXT data from one record to another

tcarnahan · September 1st, 2010, 10:56 AM

I tried seaching the archive without much success, so here is my situation.
I have a SS2K databasewith a table that has a prime key and one NTEXT field. I need to copy data from the NTEXT field in one record to the same field in another record (and overwrite the data).

I tried using:

Code:

UPDATE MyTable
SET MyNtext = (SELECT MyNtext FROM MyTable WHERE PK = 44)
WHERE PK = 66

I get the error code:

Quote:

.Net SqlClient Dataq Provider: Msg 279, Level 16, State 3, Line 40
The ntext data type is invalid in the subqquery or aggregate expression.

I started playing around with READTEXT and WRITETEXT, but I don't know how to get the output from the READTEXT to feed the input of the WRITETEXT.

Does anyone have an example of how to do this? Any help would be appreciated!

Old Pedant · September 1st, 2010, 02:16 PM

See example C near the bottom of this page:
http://msdn.microsoft.com/en-us/library/ms177523.aspx

I *THINK* you need to do:

Code:

UPDATE MyTable SET MyNtext = mt2.MyNext
FROM MyTable AS mt1, MyTable AS mt2
WHERE mt1.PK = 66 AND mt2.PK = 44

Give it a try, anyway.