Beskrivelse Spesifikasjoner Relaterte produkter A108 Produsent: Sistemi KleinLand: Italy The high quality Klein router bits satisfy the most accurate applications required by the marketplace today. In order to achieve the highest level of quality, our production department has continually invested in and equipped with the advanced technologies. Moreover we always pay detail attention to the choice of raw material, producing router bits for top market performance, precision and cutting life. To use for joints "Hoffman" system. For frames, matchboards, drawers, window and door frames, pallets and wood products in general. Dovetail bits set in wooden case see our Art. X008 - X012 USE [F9998] GO /****** Object: Trigger [dbo].[Tr_AlternativeToProd] Script Date: 22.02.2018 09.38.46 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: <22.02.2018> -- Description: -- ============================================= ALTER TRIGGER [dbo].[Tr_AlternativeToProd] ON [dbo].[AltProd] FOR UPDATE,INSERT,delete AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @ProdNo AS VARCHAR(40) DECLARE @LnNo AS INTEGER DECLARE @AltProd AS VARCHAR(40) DECLARE @Gr AS INTEGER DECLARE @DeletedGr AS INTEGER DECLARE @SumGr AS INTEGER SELECT @ProdNo = ProdNo, @LnNo = LnNo, @AltProd = AltProd, @Gr = Gr FROM inserted If @ProdNo = '' BEGIN SELECT @ProdNo = ProdNo, @LnNo = LnNo, @AltProd = AltProd, @DeletedGr = Gr FROM deleted END Select @SumGr = SUM (Gr) from AltProd where AltProd = @AltProd IF @Gr > 0 BEGIN UPDATE Prod SET Gr4 = 1 where ProdNo = @AltProd END ELSE IF @Gr = 0 and @SumGr = 0 BEGIN UPDATE Prod SET Gr4 = 0 where ProdNo = @AltProd END ELSE IF @Gr = 0 and @DeletedGr > 0 and @SumGr = 0 BEGIN UPDATE Prod SET Gr4 = 0 where ProdNo = @AltProd END END GO Forespørsel × Skjemaet er sendt. × Oops! Kjetil Hjelleset Produktansvarlig verktøy Hele landet 66 77 89 31 40 20 30 43 khj@falkenberg.no