when i run this query ......
update item set description=(select description from item where itemid=5384);
i get this error message...
Msg 279, Level 16, State 3, Line 1
The text, ntext, and image data types are invalid in this subquery or aggregate expression.
there is a lot of text in the description column of itemid 5384 (html coding) and i need to set all of the records in the table equal to it......