SQL Server 1. Create a stored procedure that takes a Recipe Name as input and th

Question

SQL Server

1. Create a stored procedure that takes a Recipe Name as input and the output is a list of ingredients with Qty and Measurement Unit.

2.Create a Stored Procedure that takes ingredient name as input and gives a list of all the recipes that either do not use this ingredient or use this ingredient in a quantity less than 1 gram.

3.Create a list of ingredients, which are used by pounds for any recipe.

4.Create a script to print the month which has the maximum number of recipes submitted.

Reclnads RecipePropertv Property Ingds ProplD PropertyName RID 7 Ingdld Ingdld ProplD Mesurld IngdName Qty Persons Person!D FirstName LastName AddressID Recipes RID RName Mesmts RecipeOwners person!D Mesurld RecipeDate MDesc RID Addresses Address!D StAddress City StateCode Zip States RecipeCats RID CID StateCode StateName Categories CatName

Explanation / Answer

1. select recipes.RName, Ingds.IngdName, RecIngds.Qty from recipes LEFT JOIN RecIngds ON recipes.RID=RecIngds.RID LEFT JOIN Ingds ON RecIngds.IngdId=Ingds.IngdId LEFT JOIN Mesmts RecIngds.MesurId=Mesmts.MesurId

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.