SET NOCOUNT ON if exists (select * from tempdb.dbo.sysobjects where name like '#WorkTable__%' and xtype ='U') DROP TABLE #WorkTable SELECT HP1.BarraID, HP1.Date AS 'Date1', HP1.Price AS 'Price1', HP2.Date AS 'Date2', HP2.Price AS 'Price2', ((HP2.Price / HP1.Price) - 1) * 100 AS Variation into #WorkTable FROM HistoPriceUSE3 AS HP1 INNER JOIN HistoPriceUSE3 AS HP2 ON HP1.BarraID = HP2.BarraID AND HP2.Date = ( SELECT MIN(Date) FROM HistoPriceUSE3 AS HP3 Where HP3.BarraID = HP1.BarraID AND HP3.Date > HP1.Date ) AND ABS((HP2.Price / HP1.Price) - 1) > 0.5 WHERE HP1.Date >= CONVERT(DATETIME,'2001/07/15',101) AND HP2.ForceVariation IS NULL SELECT HP.BarraID, TT.Ticker, TT.Name AS Compagnie, HP.Date1 AS 'Dernière date', HP.Price1 AS 'Dernier prix', HP.Date2 AS 'Date courante', HP.Price2 AS 'Prix courant', HP.Variation FROM #WorkTable AS HP INNER JOIN Titre AS TT ON HP.BarraID = TT.BarraID AND TT.Modele = 'USE3' AND TT.DateLastUpdate = ( SELECT MAX(DateLastUpdate) FROM Titre AS AA Where AA.Modele = 'USE3' AND AA.BarraID = HP.BarraID) ORDER BY HP.BarraID, HP.Date1 SET NOCOUNT OFF