CREATING A SQL PROCEDURE WITH A SUM

€10-30 EUR

Concluído

Publicado

há quase 8 anos

€10-30 EUR

Pago na entrega

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

ID do Projeto: 11016433

Sobre o projeto

2 propostas

Projeto remoto

Ativo há 8 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@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 em 0 dia