Find Jobs
Hire Freelancers

Sql snapshot in time

£10-20 GBP

종료됨
게시됨 5년 이상 전

£10-20 GBP

제출할때 지불됩니다
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
프로젝트 ID: 17364808

프로젝트 정보

5 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
5 이 프로젝트에 프리랜서들의 평균 입찰은 £16 GBP입니다.
사용자 아바타
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 1일에
5.0 (3 건의 리뷰)
2.9
2.9
사용자 아바타
Hi. Iam expertise in query writing please ping me more info i will provide you the required
£23 GBP 3일에
5.0 (1 건의 리뷰)
1.8
1.8
사용자 아바타
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 1일에
5.0 (1 건의 리뷰)
1.1
1.1
사용자 아바타
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 4일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED KINGDOM)
middlesbrough, United Kingdom
5.0
4
결제 수단 확인
4월 2, 2017부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.