Find Jobs
Hire Freelancers

Sql snapshot in time

£10-20 GBP

Avslutat
Publicerad över fem år sedan

£10-20 GBP

Betalning vid leverans
I have two tables... One Calendar table One Job table Both have a create date and a client id. I am trying to figure out at the point of someone creating a calendar event for a client at that exact point in time did any jobs against that client exist. If they did exist, was the date the job was added less than 90 days or not. I've attempted doing a join using a datediff between the create dates however what I am struggling with is the order of things. For example if someone adds a calendar event today and then puts a job on tomorrow then that is less than 90 days but actually at the time they created the calendar event e.g. Before the job was added then the job before that may have been greater than 90. Any ideas would be appreciated
Project ID: 17364808

Om projektet

5 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
5 frilansar lägger i genomsnitt anbud på £16 GBP för detta uppdrag
Använd avatar
hi, this is maulik. I am having 8 years of experience in software part and having a good experience in SQL queries. this most probably require a join of multiple tables with the condition of datediff core function of a SQL itself. I can do it and can tune your query to fetch the record as you wish. there are also some ways that I can help you with. like write a SQL query which resulted in best performance instead of taking longer time. also it would be undersble so in future you can modify it as well. I can use no lock so that other queries can't fail which are fetching record from the same table.
£10 GBP Om 1 dag
5,0 (3 omdömen)
2,9
2,9
Använd avatar
Hi. Iam expertise in query writing please ping me more info i will provide you the required
£23 GBP Om 3 dagar
5,0 (1 omdöme)
1,8
1,8
Använd avatar
Hi This looks from you description like you need 2 parameters and a sort order in the query I have an hour or so free this afternoon free, or could look at later this evening for you Relevant Skills and Experience Use SQL for all our development Proposed Milestones £19 GBP - Working Query or Procedure supplied
£19 GBP Om 1 dag
5,0 (1 omdöme)
1,1
1,1
Använd avatar
I will require both table field detail Relevant Skills and Experience I have passion for database and I will finished this task with 100% accuracy Proposed Milestones £13 GBP - After work get complete
£13 GBP Om 4 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för UNITED KINGDOM
middlesbrough, United Kingdom
5,0
4
Verifierad betalningsmetod
Medlem sedan apr. 2, 2017

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.