>update PostofficeFL set body = ( select template from TemplateFL with (nolock) where templateflid = 2 ) where Postofficeflid = @id
>

update PostofficeFL 
set body = TemplateFL.template 
FROM TemplateFL with (nolock) 
where TemplateFL.templateflid = 2 AND PostofficeFL.Postofficeflid = @id

>Server: Msg 279, Level 16, State 3, Line 10
>The text, ntext, and image data types are invalid in this subquery or aggregate expression.
>
>