ALTER procedure
[dbo].[Inventory_Alerts]
as
begin
select (select Itemname from TechInventory_ItemName where
Id=a.Itemname)as ‘Item Name’ ,DateDiff(dd,getdate(),TentativeAlert)as ‘Remaining Days’ from TechInventory_Create as
a where TentativeAlert is
not null and DateDiff(dd,getdate(),TentativeAlert)=1
end
No comments:
Post a Comment