UPDATEing a ROW
Posted on 2004-08-10
I have two rows in a table. The value of ID1 in first row is identical to value of ID2 in second row. My VB application insert first row into this table. I want to make a copy of this row in the same table. But somehow RTF fields of second row are not populated. I want to write SP to insert RTF fields of second row by using where clause (ID1 with ID2)
In query analyzer, when I run this code
insert from tablename select * from tablename where id1 = id2, I still dont see any values inserted into RTF fields.
I dont know where lies the problem.