Do you have a data type of text in one of strFastbeteckningTrakt, strFastbeteckningBlock or strFastbeteckningTecken ?If not and they are char or varchar, you can do:insert into Future_Link.dbo.tbFLink (Fastighet, Anlaggning)values ((select strFastbeteckningTrakt + ' ' + strFastbeteckningBlock + strFastbeteckningTecken + CONVERT(VARCHAR(10),intFastbeteckningEnhet)from EDPFutureGagnef.dbo.tbFuAnlaggning),(select strAnlnrfrom EDPFutureGagnef.dbo.tbFuAnlaggning))
Else you will have to use UPDATETEXT.. Look here: http://technet.microsoft.com/en-us/library/ms189466.aspx