Find Jobs
Hire Freelancers

Simple SQL Query Code Required

$70-100 AUD

已完成
已发布超过 9 年前

$70-100 AUD

货到付款
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: 6614083

关于此项目

14提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
What version of SQL Server ? Ready to start ========================================================================================
$100 AUD 在1天之内
5.0 (16条评论)
4.1
4.1
14威客以平均价$88 AUD来参与此工作竞价
用户头像
Hello, I am SQL expert. I am willing to help you do this project right now. Please contact me. Thank you
$94 AUD 在1天之内
5.0 (44条评论)
5.6
5.6
用户头像
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 在0天之内
5.0 (19条评论)
4.9
4.9
用户头像
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 在0天之内
5.0 (14条评论)
4.6
4.6
用户头像
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 在1天之内
3.9 (27条评论)
5.4
5.4
用户头像
Hi boss, I have it solved! Award it to me and will send you the sentence. Looking forward to your contact, Grunty.
$74 AUD 在0天之内
5.0 (1条评论)
4.0
4.0
用户头像
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 在1天之内
4.4 (2条评论)
2.2
2.2
用户头像
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 在1天之内
5.0 (3条评论)
0.9
0.9
用户头像
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 在3天之内
5.0 (1条评论)
0.6
0.6
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.4
0.4
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$94 AUD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Melbourne, Australia
5.0
4
付款方式已验证
会员自2月 4, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。