CREATING A SQL PROCEDURE WITH A SUM

€10-30 EUR

Completed

Posted

almost 8 years ago

€10-30 EUR

Paid on delivery

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 [login to view URL]

Database Administration

Microsoft SQL Server

SQL

Project ID: 11016433

About the project

2 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 do it. Please award my bid and hire me. I'll make you satisfy. Believe me. And Contact to me. I can start my work at once. I'll wait your visit. Thank you!

€24 EUR in 0 day