Find Jobs
Hire Freelancers

MS-SQL query

$10-30 USD

Opravljeno
Objavljeno pred skoraj 3 leti

$10-30 USD

Plačilo ob dostavi
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 projekta: 29841039

Več o projektu

9 ponudb
Projekt na daljavo
Aktivno pred 3 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
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 v 1 dnevu
5,0 (50 ocen)
6,2
6,2
9 freelancerjev je oddalo ponudbo s povprečno vrednostjo $26 USD za to delo
Avatar uporabnika
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 v 1 dnevu
5,0 (23 ocen)
4,8
4,8
Avatar uporabnika
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 v 1 dnevu
4,9 (17 ocen)
4,5
4,5
Avatar uporabnika
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 v 7 dneh
5,0 (6 ocen)
2,4
2,4
Avatar uporabnika
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 v 1 dnevu
5,0 (1 ocena)
0,8
0,8
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 5 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Saint Rose, United States
4,9
5
Plačilna metoda je verificirana
Član(ica) od jan. 27, 2014

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.