Find Jobs
Hire Freelancers

Simple SQL Query Code Required

$70-100 AUD

Terminado
Publicado hace más de 9 años

$70-100 AUD

Pagado a la entrega
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.
ID del proyecto: 6614083

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
What version of SQL Server ? Ready to start ========================================================================================
$100 AUD en 1 día
5,0 (16 comentarios)
4,1
4,1
14 freelancers están ofertando un promedio de $88 AUD por este trabajo
Avatar del usuario
Hello, I am SQL expert. I am willing to help you do this project right now. Please contact me. Thank you
$94 AUD en 1 día
5,0 (44 comentarios)
5,6
5,6
Avatar del usuario
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 en 0 día
5,0 (19 comentarios)
4,9
4,9
Avatar del usuario
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 en 0 día
5,0 (14 comentarios)
4,6
4,6
Avatar del usuario
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 en 1 día
3,9 (27 comentarios)
5,4
5,4
Avatar del usuario
Hi boss, I have it solved! Award it to me and will send you the sentence. Looking forward to your contact, Grunty.
$74 AUD en 0 día
5,0 (1 comentario)
4,0
4,0
Avatar del usuario
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 en 1 día
4,4 (2 comentarios)
2,2
2,2
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
0,9
0,9
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,4
0,4
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$94 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
5,0
4
Forma de pago verificada
Miembro desde feb 4, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.