Write sql query that do some calculations

$10-30 USD

Fullført

Lagt ut

over 7 år siden

$10-30 USD

Betalt ved levering

I need sql query that do the following [login to view URL] certain items from items table. 2..Select certain restaurants from restaurants table. [login to view URL] sum of items quantity from RequisitionDetails table for each restaurant in certain date. [login to view URL] item not existed in selected date or not existed in RequisitionDetails table at all for certain restaurant it should be empty. [login to view URL] 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 4.00 5.00 3.00 12.00 2 item2 kg 2.00 Null 1.00 3.00

Microsoft SQL Server

SQL

Prosjekt-ID: 11737902

Om prosjektet

21 forslag

Eksternt prosjekt

Aktiv 8 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@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 reviews(all 5 stars)

$20 USD om 1 dag

5,0

(1 omtale)

0,7

21 frilansere byr i gjennomsnitt $28 USD for denne jobben

@dekinghtg

A proposal has not yet been provided

$30 USD om 1 dag

4,9

(5 omtaler)

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 om 1 dag

5,0

(11 omtaler)

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 om 1 dag

5,0

(2 omtaler)

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 om 0 dag

5,0

(5 omtaler)

2,9

@rambanstola

available for new project

$30 USD om 2 dager

5,0

(1 omtale)

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 projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand. If you have any question then feel free to ask. We are here for you. Thank you Demon Developer Team

$30 USD om 1 dag

5,0

(3 omtaler)

1,4

@utkarshkatiyar19

A proposal has not yet been provided

$60 USD om 2 dager

5,0

(1 omtale)

1,2

@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 and designers (all CS grads) working 12*7. I bid only those projects which I believe i can deliver. No outsourcing or overload. You will get a direct connection with me and a regular update on the progress of work. Just joined Freelancer, looking for some jobs. Cheers!

$25 USD om 1 dag

0,0

(0 omtaler)

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 om 1 dag

0,0

(0 omtaler)

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 om 1 dag

0,0

(0 omtaler)

0,0

@arradhakrishnan

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

$25 USD om 1 dag

0,0

(0 omtaler)

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 om 1 dag

0,0

(0 omtaler)

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 long term relationship with you. Thanks & Regards Diwakar Mishra

$20 USD om 1 dag