CREATING A SQL PROCEDURE WITH A SUM
€10-30 EUR
货到付款
Hello,
I'am looking for someone to do a SQL Server PROCEDURE who return a list of 'FinishedProduct' with all the ingredients and the total sum price.
Exemple :
---------------------------------------------------------------------------------------------
The product <NameFInishedProduct> is composed of
3 <NameRawProduct> priced <BuyPrice> € each
1 <NameRawProduct> priced <BuyPrice> € each
The total price of the <NameFInishedProduct> is <SUM> €.
---------------------------------------------------------------------------------------------
///////////////////////////////////////////////////////////////////////////////////
Witch in normal output should look like
---------------------------------------------------------------------------------------------
The product Pizza is composed of
3 Tomato priced 2 € each
1 Cheese priced 1€ each
The total price of the Pizza is 7 €.
---------------------------------------------------------------------------------------------
You can find the UML of the database there
[url removed, login to view]
项目ID: #11016433
关于项目
授予:
I have been developing php and mysql programs for 7 years. I have developed and managed many web sites. So I think I can do it so that you satisfy. I am looking forward to being hired by you. I'll do my best to d 更多