SHOW:
|
|
- or go back to the newest paste.
| 1 | CREATE VIEW dbo.uvw_StockingDays | |
| 2 | AS | |
| 3 | SELECT ItemNmbr | |
| 4 | , ItemDesc | |
| 5 | - | , dbo.ufn_SplitGet(USCATVLS_1, '-', 1) AS MinDays -- custom function that splits the text on '-' and returns the first index |
| 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 -- the last two columns |
| 13 | + | IF (COLUMNS_UPDATED() & 12) > 0 |
| 14 | UPDATE IV00101 | |
| 15 | - | SET USCATVLS_1 = MinDays + '-' + MaxDays -- invalid column names |
| 15 | + | SET USCATVLS_1 = INSERTED.MinDays + '-' + INSERTED.MaxDays |
| 16 | - | WHERE IV00101.ItemNmbr = ItemNmbr -- want to refer to view's itemnmbr |
| 16 | + | FROM INSERTED |
| 17 | WHERE IV00101.ItemNmbr = INSERTED.ItemNmbr | |
| 18 | GO |
