Design / Sql Query options
Posted on 2011-02-16
Using MSSQL 2008R2 , I am looking for suggestions on how to best handle this situtation.
Example of recipes and ingredients.
I have recipes table that list recipe_id, ingredient_id that links to a Ingredient table that has current price.
However, some recipes ingedients are really "sub-recipes" that are listed in teh same recipe table.
My 2 questions:
1) How to handle recipes that have multiple "sub-recipes"?
2) How to best handle previous costs, I want to compare costs of ingredients between today and 1 year ago? Currently, my ingredient table lists on last bought price.