Simple SQL Query Code Required

$70-100 AUD

Fullført

Lagt ut

over 9 år siden

$70-100 AUD

Betalt ved levering

I require SQL query code (not just the result) to find the daily average takings across a week for numerous Cash Registers. Please find sample data and required outcome attached.

Microsoft SQL Server

SQL

Prosjekt-ID: 6614083

Om prosjektet

14 forslag

Eksternt prosjekt

Aktiv 10 å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:

@cheapexcell

What version of SQL Server ? Ready to start ========================================================================================

$100 AUD om 1 dag

5,0

(16 omtaler)

4,1

14 frilansere byr i gjennomsnitt $88 AUD for denne jobben

@manhpham

Hello, I am SQL expert. I am willing to help you do this project right now. Please contact me. Thank you

$94 AUD om 1 dag

5,0

(44 omtaler)

5,6

@milansahu2010

Hello Sir/Madam, I hope you are having an easy week. My name is Milan Sahu from Kolkata, India. I am a SQL SERVER Developer. I am willing to do your project. I checked your requirement and i want to work with you. Please check my profile with good feedback. I am interested in a long term relationship with you. Waiting for a positive reply. Thnkz & regards Milan Sahu, kolkata, India

$100 AUD om 0 dag

5,0

(19 omtaler)

4,9

@sswijaya

Hi, Please check my query here: SELECT DATEPART(YYYY,datetimeStamp)*100+DATEPART(WEEK,datetimeStamp) WeekId, DATEADD(week, DATEDIFF(week, 0, datetimeStamp), 0) [Week Beginning], Register, AVG(Sales) [AverageDailySales] FROM sales GROUP BY DATEPART(YYYY,datetimeStamp)*100+DATEPART(WEEK,datetimeStamp), DATEADD(week, DATEDIFF(week, 0, datetimeStamp), 0), Register Let me know if you need adjustment with the query. Looking forward for your reply. Regards, Susanto

$70 AUD om 0 dag

5,0

(14 omtaler)

4,6

@acronymsolutions

Hi, I have gone through your requirements ,I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now

$95 AUD om 1 dag

3,9

(27 omtaler)

5,4

@Grunty

Hi boss, I have it solved! Award it to me and will send you the sentence. Looking forward to your contact, Grunty.

$74 AUD om 0 dag

5,0

(1 omtale)

4,0

@ekajgho

Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience includes Telecom Application (OSS & BSS Rating and Billing), Financial Application, ERP-Application, and School Application, Central and State Govt. Offices application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, MVC 4.0, Entity Framework 4.0, Visual Basic, Crystal Report, MS SQL Server, Oracle and MS Access. I have a ready made code for it and can quickly deliver with few tweaks only. Very commited to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.

$88 AUD om 1 dag

4,4

(2 omtaler)

2,2

@ripasahasl

Hello Sir, I'm interested in Your job and I'm available to do this task right now. I've 1 below question related to this job:- what do You mean by WeekId in result? Looking forward to hear from You. Thanks,

$80 AUD om 1 dag

5,0

(3 omtaler)

0,9

@solutionland2014

Hi I'm an IT student with good knowledge in sql. I will hope can help you to do your job. I'm new here and need to do some good project and successful results for build my business. I will promise you will be happy with results. regards

$70 AUD om 3 dager

5,0

(1 omtale)

0,6

@arunoday1981

Hi, This is Arunoday from Gurgaon, India having an IT and Database experience of 10 years. I have worked on multiple database projects and have solved numerous similar queries. Awaiting positive confirmation on this assignment. Thanks, Arunoday Sinha Mobile : +91 97112 07595

$77 AUD om 3 dager

0,0

(0 omtaler)

0,0

@rajshekhar024

Hello Dear, we have seen your request and do this project with out issues. We are a team of core experts and can carry any request related to SQL. We are new to this platform and will offer you a very competitive rate. Lets discuss and you will get to know ,how we will complete the task. our skype is raj.shekhar_2 Hope to hear from you. Warm Regards Raj

$94 AUD om 1 dag

0,0

(0 omtaler)

0,4

@lilneon

I have years of experience writing SQL queries like these. Guaranteed to get your work done, in the shortest possible space of time. I will write a simple query with the fields you ask for, and can even give you extra fields if you wish. Formatting as well, sample results below for verification. weekid WeekBeginning Register totalSales avgDailySales 201442 10-15-2014 1100 522.50 87.0833 201442 10-15-2014 1101 298.30 49.7166 201442 10-15-2014 1102 409.00 68.1666 201442 10-15-2014 1103 685.60 114.2666 Thank you for your business.

$94 AUD om 1 dag