infogulch

Untitled

Mar 15th, 2012
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE VIEW dbo.uvw_StockingDays
  2. AS
  3. SELECT ItemNmbr
  4.      , ItemDesc
  5.      , dbo.ufn_SplitGet(USCATVLS_1, '-', 1) AS MinDays
  6.      , dbo.ufn_SplitGet(USCATVLS_1, '-', 2) AS MaxDays
  7. FROM IV00101
  8. GO
  9.  
  10. CREATE TRIGGER dbo.upd_StockingDays
  11. ON uvw_StockingDays
  12. INSTEAD OF UPDATE AS
  13. IF (COLUMNS_UPDATED() & 12) > 0
  14.     UPDATE IV00101
  15.     SET USCATVLS_1 = INSERTED.MinDays + '-' + INSERTED.MaxDays
  16.     FROM INSERTED
  17.     WHERE IV00101.ItemNmbr = INSERTED.ItemNmbr
  18. GO
Advertisement
Add Comment
Please, Sign In to add comment