Dibatalkan

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]

Keahlian Microsoft SQL Server, SQL

Lihat lebih lanjut: tree query sql, sql write query, dnn query sql, php html query sql, vbs sql write, parent child query sql, query sql 2005 csv

Tentang Pemberi kerja:
( 5 ulasan ) Doha, Qatar

ID Proyek: #11737902

Diberikan kepada:

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 Lagi

$20 USD dalam 1 hari
(1 Ulasan)
0.7

21 freelancer menawar pada rata-rata $28 untuk pekerjaan ini

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 dalam 1 hari
(36 Ulasan)
5.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 dalam 1 hari
(11 Ulasan)
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 dalam 1 hari
(2 Ulasan)
3.3
dekinghtg

A proposal has not yet been provided

$30 USD dalam 1 hari
(5 Ulasan)
3.4
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 dalam 0 hari
(5 Ulasan)
2.9
rambanstola

available for new project

$30 USD dalam 2 hari
(1 Ulasan)
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 Lagi

$30 USD dalam 1 hari
(3 Ulasan)
1.4
utkarshkatiyar19

A proposal has not yet been provided

$60 USD dalam 2 hari
(1 Ulasan)
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. Lagi

$45 USD dalam 1 hari
(1 Ulasan)
0.8
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 Lagi

$25 USD dalam 1 hari
(0 Ulasan)
0.0
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 Lagi

$20 USD dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
0.0
$15 USD dalam 1 hari
(0 Ulasan)
0.0
arradhakrishnan

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

$25 USD dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
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, Lagi

$23 USD dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
0.0