#create trigger

– DROP TRIGGER dbo.tr_Invoice_SetTradingGrp CREATE TRIGGER tr_Invoice_SetTradingGrp ON [dbo].[LG_XXX_01_INVOICE] AFTER INSERT, UPDATE AS BEGIN UPDATE T SET T.TRADINGGRP = CASE I.SPECODE WHEN ‘GRUP_A’ THEN 1 WHEN ‘GRUP_B’ THEN 2 ELSE 0 END FROM [dbo].[LG_XXX_01_INVOICE] AS T INNER JOIN INSERTED AS I ON T.LOGICALREF = I.LOGICALREF END

Set your smart lights to turn on gradually as you wake up – CNET

facebook twitter linkedin googleplus email comments more reddit pinterest tumblr Taylor Martin/CNET Smart lights are great in that they can be programmed to work in whatever way suits you best. If you want, you can wake up to them in the morning with a simulated sunrise. They can turn off at certain times each night, letting you know you should probably head to bed and not watch just one more…