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:
SET MyNtext = (SELECT MyNtext FROM MyTable WHERE PK = 44)
WHERE PK = 66
I get the error code:
.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!