SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


            CREATE TRIGGER[dbo].[pricechangeTrigger]
        ON[dbo].[pricechange]
        AFTER INSERT
            AS
                BEGIN
            -- SET NOCOUNT ON added to prevent extra result sets from
                -- interfering with SELECT statements.
                SET NOCOUNT ON;

            -- Insert statements for trigger here

              WITH PriceChange_CTE (code, vmecode,storeCode)
              AS
              (
                    SELECT
                        pricechange.code,
                        pricechange.vmecode,
                        storeinfo.code
                    from inserted
                    INNER JOIN pricechange on pricechange.code = inserted.code
                    INNER JOIN prices on pricechange.vmecode = prices.vmecode AND pricechange.band = prices.band
                    INNER JOIN [range] on [range].vmecode = prices.vmecode
                    INNER JOIN [pricerange] on [pricerange].rangenames = [range].rangenames
                    inner join storeinfo on storeinfo.code = [pricerange].store
            )

                INSERT INTO pricechangeworker  (code, vmecode,storeCode)

                SELECT code, vmecode,storeCode FROM PriceChange_CTE

END

GO

ALTER TABLE [dbo].[pricechange] ENABLE TRIGGER [pricechangeTrigger]
GO