update PostofficeFL set body = ( select template from TemplateFL with (nolock) where templateflid = 2 ) where Postofficeflid = @idI'm getting this error:
Server: Msg 279, Level 16, State 3, Line 10 The text, ntext, and image data types are invalid in this subquery or aggregate expression.