Find Jobs
Hire Freelancers

Sql snapshot in time

£10-20 GBP

Cerrado
Publicado hace más de 5 años

£10-20 GBP

Pagado a la entrega
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 del proyecto: 17364808

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
5 freelancers están ofertando un promedio de £16 GBP por este trabajo
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
2,9
2,9
Avatar del usuario
Hi. Iam expertise in query writing please ping me more info i will provide you the required
£23 GBP en 3 días
5,0 (1 comentario)
1,8
1,8
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
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 en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
middlesbrough, United Kingdom
5,0
4
Forma de pago verificada
Miembro desde abr 2, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.