Find Jobs
Hire Freelancers

MySQL - Debug VIEW

$30-250 USD

Kansellert
Lagt ut nesten 6 år siden

$30-250 USD

Betalt ved levering
*** PLEASE SEE ATTACHED FILE FOR FULL BUG DESCRIPTION I have a view (daily_schedule) that returns a list of all bus passengers that need to be picked up on a given day (monday - sunday). When a user is picked up, a record is written to a table named "trip_history". This table contains a date/timestamp for that ride. 2 rides are allowed per day/per rider - the ride to their destination and their ride home. Each Union statement represents a day of the week. Only one SELECT statement should run per day depending on the day of week (MON-SUN). Each SELECT has a CASE option in it. This CASE logic is meant to determine if a passenger has already been transported on the bus in the morning/AM (first case statement) or the afternoon/PM (second case statement). If the statement execution happens in the AM and the passenger already has a "trip" record recored for an AM ride, the query should return "TRANSPORTED" for the pickup_status. Likewise, if the statement execution happens in the PM, the query should also return "TRANSPORTED" for the pickup_status. Otherwise, the pickup_status should be NULL. File Attachments: 1. BUG [login to view URL] 2. All .SQL files needed
Prosjekt-ID: 17213436

Om prosjektet

9 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
9 freelancers are bidding on average $137 USD for this job
Brukeravatar
Hello feign3vw. Do you need be picked up on a given day (monday - sunday) ?.I think i can do this project Our skills same your requirement skills : SQL, Database Programming, MySQL, Debugging. I always: -Do project fast as possible. -Charge a reasonable cost. -Provide Quality Product. All my previous project was feedbacked 5 stars. because i care the customer feeling. Let me help you do this project by text me via inbox
$165 USD om 4 dager
5,0 (50 omtaler)
6,0
6,0
Brukeravatar
hello,dear. It's my pleasure meeting you. I have read your requirements and I fully went through it. I am confident and I am sure that I am able to finish such project. Would you contact me for further discussing. Thanks for your interests.. MySQL - Debug VIEW Database Programming, Debugging, MySQL, SQL,
$155 USD om 1 dag
5,0 (1 omtale)
1,2
1,2
Brukeravatar
Hi Hiring Manager, I’m interested in the job of checking and changing MySQL view you recently posted. I have been professional database manager for 5 years, and am very familiar with Excel, SQL Server and Python. You had mentioned that you were looking for someone with a lot of experiences with databases. I have been dealing with this for several years and I ensure that the work will be carried out reliably. I have experience in MySQL and SQL Server, so I can handle this project. I have two an additional question: 1. What is the time to complete the entire task? Please feel free to contact me directly to discuss this job further. Best Regards Lukasz
$166 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi. Problem doesn't look very difficult. I'm sure I can help you. I didn't solve it yet because your zip file lack of definition of daily_schedule. Also there is no definition of problematic view.
$111 USD om 1 dag
0,0 (0 omtaler)
0,7
0,7
Brukeravatar
Hello, I am interested in your project, I am a Senior .net Software Engineer with 6+ years of working experience in Software applications full life cycle. i have read carefully the attached document for bug description and i run all the attached scripts on my environment but i didn't find the script that creates the "daily_schedule "view, which has the problem i found insertion in table called "daily_schedule" so i created it but i still need the script that creates the view because the problem mainly is there. I am expert in .Net 4.6, Asp.net, REST / SOAP web services,Json, WCF, MVC 5, JavaScript, JQuery, Asp.net Web API, LINQ, Entity Framework, Amazon MWS, HTML, XML,CSS, PL/SQL. Actually, I am still building my profile here that's why I am offering a low cost, my only concern now is client satisfaction. I hope I can help you and it would be my pleasure to complete and deliver your task.
$77 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I have around 40 years experience in IT ANDnad around 15 years experience in Web Development including SQL
$77 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

CANADAs flagg
huntley, Canada
5,0
145
Betalingsmetode bekreftet
Medlem siden aug. 24, 2005

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.