Find Jobs
Hire Freelancers

Sql snapshot in time

£10-20 GBP

Closed
Posted over 5 years ago

£10-20 GBP

Paid on delivery
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

About the project

5 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average £16 GBP for this job
User 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 in 1 day
5.0 (3 reviews)
2.9
2.9
User Avatar
Hi. Iam expertise in query writing please ping me more info i will provide you the required
£23 GBP in 3 days
5.0 (1 review)
1.8
1.8
User 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 in 1 day
5.0 (1 review)
1.1
1.1
User 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 in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
middlesbrough, United Kingdom
5.0
4
Payment method verified
Member since Apr 2, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.