Simple SQL Query Code Required

$70-100 AUD

I përfunduar

Postuar

over 9 years ago

$70-100 AUD

Paguhet në dorëzim

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

ID e Projektit: 6614083

Rreth projektit

14 propozime

Projekt në distancë

Aktive 10 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@cheapexcell

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

$100 AUD në 1 ditë

5,0

(16 përshtypje)

4,1

14 profesionistët e pavarur ofrojnë mesatarisht $88 AUD oferta për këtë punë

@manhpham

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

$94 AUD në 1 ditë

5,0

(44 përshtypje)

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 në 0 ditë

5,0

(19 përshtypje)

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 në 0 ditë

5,0

(14 përshtypje)

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 në 1 ditë

3,9

(27 përshtypje)

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 në 0 ditë

5,0

(1 review)

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 në 1 ditë

4,4

(2 përshtypje)

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 në 1 ditë

5,0

(3 përshtypje)

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 në 3 ditë

5,0

(1 review)

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 në 3 ditë

0,0

(0 përshtypje)

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 në 1 ditë

0,0

(0 përshtypje)

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 në 1 ditë