Cancelado

Write sql query that do some calculations

I need sql query that do the following

[url removed, login to view] certain items from items table.

2..Select certain restaurants from restaurants table.

[url removed, login to view] sum of items quantity from RequisitionDetails table for each restaurant in certain date.

[url removed, login to view] item not existed in selected date or not existed in RequisitionDetails table at all for certain restaurant it should be empty.

[url removed, login to view] the total

data base backup and script are included in the attachment.

out put should be like this

Cod ItemName Unit res1 res 2 res3 Total

1 item1 kg [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]

2 item2 kg [url removed, login to view] Null [url removed, login to view] [url removed, login to view]

Habilidades: Microsoft SQL Server , SQL

Ver mais: write tree structure query sql, write query sql number orders shipped, display salary decimal oracle sql write query, arcgis vba query sql server, tree query sql, sql write query, dnn query sql, php html query sql, uusing data adaptor aspnet query sql server database, vbs sql write, parent child query sql server, sql server importing outlook attachment, net query sql mobile table example, parent child query sql, query sql 2005 csv, query sql parent child result set

Acerca do Empregador:
( 5 comentários ) Doha, Qatar

ID do Projeto: #11737902

Premiar a:

bhaveshghodasara

Looks easy and straight forward, is is possible for you to give sample data in some other format then db? I just need tablename and columnnames of each table. I can do it in 3-4 hours only. You can check my past Mais

$20 USD em 1 dia
(1 Comentário)
0.7

21 freelancers estão ofertando em média $28 para este trabalho

manhpham

My name is Manh from Vietnam. I read your project details and I am sure I can complete your project.Can we can chat/discuss further on your project?

$45 USD em 1 dia
(36 Comentários)
5.4
dekinghtg

A proposal has not yet been provided

$30 USD em 1 dia
(5 Comentários)
3.4
angnut

HI, I can do your sql task today. I will delivery it in my afternoon (Rome Time). Please contact me if it is ok for you. Have a nice day. Angelo

$30 USD em 1 dia
(11 Comentários)
3.2
thampl

Hi there, I'm Tom and I can write SQL for you. I can start with job today and it will be done today. Regards, Tom

$27 USD em 1 dia
(2 Comentários)
3.3
mehulprajapati91

I can start working right now.I can start working right now.I can start working right now.I can start working right now. Thanks,MEHUL

$30 USD in 0 dias
(5 Comentários)
2.9
rambanstola

available for new project

$30 USD in 2 dias
(1 Comentário)
1.8
DemonDeveloper

We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for project Mais

$30 USD em 1 dia
(3 Comentários)
1.4
utkarshkatiyar19

A proposal has not yet been provided

$60 USD in 2 dias
(1 Comentário)
1.2
saedabaid

Dear sir ,I read your proposal well. Please make sure i will exceed your expectation , thanks .. I’d happy to provide you some samples that you can review those before making hiring decision. http://www.eureeca. Mais

$45 USD em 1 dia
(1 Comentário)
0.8
diwakarm801

Hi I have been working in Asp.Net, MVC, Angularjs, Web Services, WCF , SQL Server since last 4 years.I am confident that i can finish your task in a jiffy. it's have a detail discussion. Looking forward to make a Mais

$20 USD em 1 dia
(0 Comentários)
0.0
w3esolution

I can assure 100% satisfaction in this project , please come on chat to discuss more .. Ready to start the work now..

$25 USD em 1 dia
(0 Comentários)
0.0
rikred

proficient in sql, i am regularly exposed to datasets in excess of 1 million records, your query will be efficient and accurate.

$20 USD em 1 dia
(0 Comentários)
0.0
ravirich20

I have a candidate who is having 6+ years of SQL Database experience and he is currently working in MNC. So we can complete your work with quality and within timeframe.

$25 USD em 1 dia
(0 Comentários)
0.0
wasifmuneer

Hello, Please give me chance to work with you on this project, I am Microsoft Full Stack developer, having expertise on web based and desktop base application development, including mobile apps as well using Xamarin, Mais

$23 USD em 1 dia
(0 Comentários)
0.0
logodesigingpk

Hello Sir, I am a php developer and able to create such query and fetch data from your database on the following condition. i am working in IT Field from last 4 years. thanks!!!

$30 USD em 1 dia
(0 Comentários)
0.0
vishnu20sankar

Hi,being a data analyst I have strong grasp on SQL queries.You can trust me with your job without shelling out too much money

$10 USD em 1 dia
(0 Comentários)
0.0
sdsubha8

I am a Software Engineer.I have experience on it.If you will give me a chance to prove myself , we will discuss further.

$20 USD em 1 dia
(0 Comentários)
0.0
$15 USD em 1 dia
(0 Comentários)
0.0
chetanghadiya007

Hi, I am chetanghadiya007 from Rajkot,Gujarat,India. i'm developers and designer with around 6 years of experience. Completely passionate and self dependent. I believe in delivery with a quality. i'm developers an Mais

$25 USD em 1 dia
(0 Comentários)
0.0
arradhakrishnan

Expert in stored procedure, TSQL, functions and db/table design.

$25 USD em 1 dia
(0 Comentários)
0.0