I have a mssql 2005 database dbTest with to tables tblOne and tblTwo. tblTwo.IndexID = tblOne.IndexID. tblOne and tblTwo has both got fields, tblOne.Article and tblTwo.Article which is set to type(ntext). tblOne has less records than tblTwo and I would only like to update the record fields where tblOne occurs in tblTwo My question is, how can I update all tblTwo.Article fields from tblTwo.Article where tblTwo.IndexID = tblOne.IndexID if it is ntext.
