DECLARE @FirstTable TABLE (RandomInteger nvarchar)
BEGIN
INSERT INTO @FirstTable
SELECT column corresponding to randominteger field
FROM generic.DailyPrice 
inner
join generic.Simulation
on generic.DailyPrice.ISIN =generic.Simulation.ISIN
where Date=
(SELECT MAX(Date) FROM generic.DailyPrice)
end
go

DECLARE @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 dp
inner
  join generic.Simulation s
  on dp.ISIN =s.ISIN
where Date=
  (SELECT MAX(Date) FROM generic.DailyPrice)