CREATE VIEW dbo.Valid
AS
SELECT dbo.ProInStore.StoreProId AS 倉庫存儲編號, dbo.Product.ProName AS 產品名稱, 
      dbo.ProInStore.ProPrice AS 產品價格, dbo.ProInStore.ProNum AS 產品數量, 
      dbo.ProInStore.CreateDate AS 生產日期, dbo.Storehouse.StoreName AS 倉庫名稱, 
      ROUND(DATEDIFF(day, DATEADD(day, dbo.Product.Valid, dbo.ProInStore.CreateDate), 
      GETDATE()), 0) AS 距離失效期的天數
FROM dbo.ProInStore INNER JOIN
      dbo.Product ON dbo.ProInStore.ProId = dbo.Product.ProId AND DATEDIFF(day, 
      GETDATE(), dbo.ProInStore.CreateDate) 
      >= dbo.Product.Valid - dbo.Product.AlarmDays INNER JOIN
      dbo.Storehouse ON dbo.ProInStore.StoreId = dbo.Storehouse.StoreId