Sql snapshot in time

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

Taidot: tietojärjestelmäarkkitehtuuri, testaus/laadunvarmistus, Windows Desktop

Näytä lisää: sql server snapshot backup, sql server database snapshot performance, sql server table snapshot, how to take snapshot backup in sql server, sql server restore from snapshot, how to create database snapshot in sql server 2012, sql server database snapshot, how to create database snapshot in sql server step by step, sql server time, sql server time attendance, sql logon time, sql part time, vb6application slow sql server time, sql write time project, sql hotel time prices, ms sql part time, improve sql query time oscommerce, asp net calendar application autopopulate sql server time schedules, gtm time sql add time, sql installation time requirement

Tietoa työnantajasta:
( 4 arvostelua ) middlesbrough, United Kingdom

Projektin tunnus: #17364808

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello. I am web developer. Relevant Skills and Experience Software Architecture, Testing / QA, Windows Desktop Proposed Milestones £18 GBP - Finish

£18 GBP 1 päivässä
(4 arvostelua)

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 Us Lisää

£19 GBP 1 päivässä
(0 arvostelua)

Hi. Iam expertise in query writing please ping me more info i will provide you the required

£23 GBP 3 päivässä
(0 arvostelua)

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 päivässä
(0 arvostelua)
£13 GBP 2 päivässä
(0 arvostelua)

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 Lisää

£10 GBP 1 päivässä
(0 arvostelua)