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

Kemahiran: Kejuruteraan Perisian, Ujian / Jaminan Kualiti , Destop Windows

Lihat lagi: 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

Tentang Majikan:
( 4 ulasan ) middlesbrough, United Kingdom

ID Projek: #17364808

6 pekerja bebas membida secara purata £16 untuk pekerjaan ini


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

£18 GBP dalam sehari
(4 Ulasan)

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 Lagi

£19 GBP dalam sehari
(0 Ulasan)

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

£23 GBP dalam 3 hari
(0 Ulasan)

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 dalam 4 hari
(0 Ulasan)
£13 GBP dalam 2 hari
(0 Ulasan)

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 Lagi

£10 GBP dalam sehari
(0 Ulasan)