Find Jobs
Hire Freelancers

MS-SQL query

$10-30 USD

完了済み
投稿日: 3年近く前

$10-30 USD

完了時にお支払い
I need help for a SQLquery as follows:. There are three tables: EmployeeList table: .ID , CompanyId, FullName, varInOrOut, Companies table: ID, [Name] MinutesWorked table: EmployeeId, TimeStarted, TimeFinished Using these tables, I want to have a result table like this: Column0: [login to view URL] Column1: [login to view URL] Column2: [login to view URL] Column3: WEEK1 (total Minutes) Column4: WEEK2 (total Minutes) Column5: WEEK3 (total Minutes) Column6: WEEK4 (total Minutes) Column 3,4,5,6 will show total minutes between TimeFinished and TimeStarted (Week4: this week, Week3 last week, Week2 previous week, Week1 week before previous week) If EmployeeList.varInOrOut=In this record will be ignored. for every Employee there will be only one row One row for every employee in the company I need this query to be done TODAY. If you will not be able to work today then there is no need to work.
プロジェクト ID: 29841039

プロジェクトについて

9個の提案
リモートプロジェクト
アクティブ 3年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hello there, i'm ready to do your job right now. Within this query i think it will take me at most 1-2 hours. Waiting for your response now if interested. Thank you!!!
$35 USD 1日以内
5.0 (50 レビュー)
6.2
6.2
この仕事に9人のフリーランサーが、平均$26 USDで入札しています
ユーザーアバター
Namaste! Are you looking for a SQL Server Expert for your project? About me: I'm SQL Server's Performance and Emergency Expert; with 6+ years of professional experience in 5 high performance OLTP (Online Transaction Processing) systems and 15+ freelancer projects. About SQL Server Performance: It's hard to make our server 100x faster - but it's really easy to make our database design and queries suddenly 100x more efficient. Fixing queries and tables and indexes is indeed hard work - but it's totally worth it. Warm regards, The affordable consultant :)
$60 USD 1日以内
5.0 (23 レビュー)
4.8
4.8
ユーザーアバター
Dear employer. With 5 years of experience working as sql developer, I can help you immediately. Please send a message to me then I can start working. Have a great day. Thank you
$35 USD 1日以内
4.9 (17 レビュー)
4.5
4.5
ユーザーアバター
Hi Client, I have 3+ years of experience working as a SQL developer. I can help you with your task. Please reach me on chat window we can discuss on this. Thanks. Regards, Vinod
$15 USD 7日以内
5.0 (6 レビュー)
2.4
2.4
ユーザーアバター
Dear Sir/Ma'am, I am full time experienced web developer. I have read your project details and I am ready to start work on your project and give you best results as you want. If you want to check my previous work then you can check my portfolio for your reference, I have done many project in PHP and also done Angular 4,5,6 to 11 project with back end PHP, WordPress, Node.js, Shopify, Laravel, WooCommerce, Codeigniter. Just message me once if you want to discuss more about project as I always be there. Waiting for your reply Thanks & Regards, Kishan Chauhan
$30 USD 1日以内
5.0 (1 レビュー)
0.8
0.8
ユーザーアバター
Hi As a Software Engineer I have good skill set to develop and deploy Web Application.I read your requirements and I have good hands sql queries please let me this opportunity
$10 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello, I am a Java / Android developer with 2 years of experience. I have also worked in creating database structures and writing queries and hope to help you.
$15 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi there, I have working experience on Ms SQL and Ms-Excel. I have worked on projects using sql and would like to take on this task to complete it in time. I would provide timely updates on the completed tasks and the charge is also negotiable if required.
$15 USD 5日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Saint Rose, United States
4.9
5
お支払い方法確認済み
メンバー登録日:1月 27, 2014

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。