DECLARE @FirstTable TABLE
(
  Fk_fund int,
  Date datetime,
  isin nvarchar(12),
  Fundname ntext,
  ShareCurrency nvarchar(3),
  Pricepershare numeric,
  exchanegRate numeric,
  FirstSimulation nvarchar(20),
  SecondSimulation nvarchar(20),
  ThirdSimulation nvarchar (20)
)
    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)
  
 select * from generic.HistoricalPrice hp
inner
join @FirstTable 
on hp.ISIN = @FirstTable.ThirdSimulation
where hp.Date > @FirstTable.date

select * from generic.HistoricalPrice hp
inner
join @FirstTable 
on hp.ISIN = @FirstTable.ThirdSimulation
where hp.Date > @FirstTable.date

select * from generic.HistoricalPrice hp
inner
join @FirstTable ft
on hp.ISIN = ft.ThirdSimulation
where hp.Date > ft.date

quote:

---

Originally posted by rjhe22

got it this fixes it

select * from generic.HistoricalPrice hp
inner
join @FirstTable ft
on hp.ISIN = ft.ThirdSimulation
where hp.Date > ft.date

---