I have a table name RECIPECLASSVARIABLE which contains a set of parameters identify by VARIBALE_ID for each RecipeClass_ID
Consider this table as a "BASE" recipe table.
Then when I create recipes, for each created recipe it will inherit the list of parameter for its corresponding recipeClass ID from RECIPECLASSVARIBALE
In other word, if I add a new parameter in RECIPECLASSVARIBALE for a particular RECIPECLASS_ID, that parameter must be added to all recipe created from that same RECIPECLASS_ID.
IN order to try to do that, each time a new parameter gets inserted in RECIPECLASSVARIABLE table the following trigger gets executed :
ALTER TRIGGER [dbo].[AddRecipeValue]
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
View Complete Post