have it like this nowDECLARE @FirstTable TABLE( Fk_fund int, Date datetime, isin nvarchar, Fundname ntext, ShareCurrency nvarchar, Pricepershare numeric, exchanegRate numeric, FirstSimulation nvarchar, SecondSimulation nvarchar, ThirdSimulation nvarchar) INSERT INTO @FirstTable (Fk_fund, Date,isin,Fundname,ShareCurrency, Pricepershare, exchanegRate,FirstSimulation,SecondSimulation,ThirdSimulation)SELECT dp.Fk_fund , dp.Date , dp.isin , dp.Fundname, dp.ShareCurrency , dp. Pricepershare , dp. exchanegRate , s.FirstSimulation , s.SecondSimulation , s.ThirdSimulation FROM generic.DailyPrice dpinner join generic.Simulation s on dp.ISIN =s.ISINwhere Date= (SELECT MAX(Date) FROM generic.DailyPrice)
getting this errorMsg 8152, Level 16, State 13, Line 21String or binary data would be truncated.The statement has been terminated.