CREATE VIEW dbo.SON_BITIS_TARIHI
AS
WITH LastZeroDates AS (SELECT   STOCKREF, MAX(DATE_) AS LastZeroDate
                                                                   FROM         dbo.StokHareketleriTumu
                                                                   GROUP BY STOCKREF)
    SELECT   STOCKREF, LastZeroDate, DATEDIFF(DAY, LastZeroDate, CAST(GETDATE() AS DATE)) AS GunSay
     FROM         LastZeroDates AS lzd