CREATING A SQL PROCEDURE WITH A SUM

已完成 已发布的 7 年前 货到付款
已完成 货到付款

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]

数据库管理 微软 SQL 服务器 SQL

项目ID: #11016433

关于项目

2个方案 远程项目 活跃的7 年前

授予:

mysunmoon33

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 更多

€24 EUR 在0天内
(0条评论)
0.0