Find Jobs
Hire Freelancers

Need help with the sql query

$10-30 USD

Cerrado
Publicado hace alrededor de 5 años

$10-30 USD

Pagado a la entrega
Need help with the sql query for the following: Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice date, for each supplier. Join this back to SA2330 on supplier ID and then change Payment Terms from NULL to E4_DESCRI in the subquery. Please help me on this one. Thanks, MMB
ID del proyecto: 18686945

Información sobre el proyecto

30 propuestas
Proyecto remoto
Activo hace 5 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
30 freelancers están ofertando un promedio de $22 USD por este trabajo
Avatar del usuario
I am oracle certified SQL developer. I can do this very well. Lets talk and solve this problem. I am waiting for your response
$25 USD en 20 días
5,0 (24 comentarios)
4,7
4,7
Avatar del usuario
I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about the project.
$10 USD en 3 días
5,0 (6 comentarios)
4,0
4,0
Avatar del usuario
Hi there! Have done this type of work before and am a SQL expert. Please feel free to message me with additional information or with questions if any, thanks!
$15 USD en 1 día
4,7 (10 comentarios)
4,2
4,2
Avatar del usuario
hi i am expertise in sql server and sql querying please let me knowif you are intersted , ping me for more details
$30 USD en 1 día
4,8 (10 comentarios)
4,1
4,1
Avatar del usuario
Hello dear, I see that you are needing help with a SQL query, I am SQL expert and I can help you with that. Contact me and I will solve it quickly.
$25 USD en 1 día
5,0 (4 comentarios)
2,3
2,3
Avatar del usuario
Hey there, Longtime MySQL dev here, would be happy to help. Could you send me a database schema, and then we can figure things from there? Being able to see your DB structure would really help putting your problem in context. Thanks
$30 USD en 1 día
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
I read your description carefully and I am very confident that I can complete the task. Please don't hesitate to chat with me to discuss further details about the script. Have a nice day. Best regards, Vasileios A.
$20 USD en 3 días
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
I have good experience working with Sql queries for over 6 years. I have seen your project requirements and I am sure I would be able to complete this project as required in the given time frame.
$25 USD en 1 día
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
HI I can easily and very quickly do this for you, in just a few hours. I have 15 years experience and have written thousands of complex Sql server Stored procedures, Triggers, Functions, tables sing T-SQL 2016/2014/2012/2008-R2/2005 I also have vast experience in building complex Business intelligence solutions as well as bespoke Web applications and user interfaces. Please have a look at my experiences. Thank you
$25 USD en 1 día
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hi, Hope you are doing good. I have gone through the full project description carefully. As 7+ years experienced SQL server developer, I can finish this project for 2 days at free of cost since I am new to the freelancers. Kindly give me a high rating if you are impressed by my work and completeness. Kindly ping me once you are ok with my proposal and have hope for me. Thank You.
$10 USD en 2 días
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
hello i will be the good choice for this task having 3year experience in web development you may visit portfolio looking forward to get connected
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Expert in SQL,Plsql
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am very good in sql writing and can help you with this requirement
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am working professional with 3 + years of experience database concepts and SQL database administration
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello Sir, I can do this query FREE of cost for you. Just rate me 5 stars if you like my work. Regards, Faisal Saeed.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Call me on my cell. It will not take more than 10 mins to be done. (Nine Nine eight five nine two seven six seven three).
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello sir, I use to work with sql server databases with more then 200 tables. Let me do this task with no delay .
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello , I came across your project and would be a pleasure to offer my help on this task. Per the project description, the final target is to update the Supplier information with the most recent payment type. If the data set does exist within a SQL Server DB, this can be accomplished by a T-SQL procedure that does the following: 1-Join info from SD1330 & SF1330. 2-A common Table Expression (CTE) code will run against table SE4330 partitioning by supplier and ordering by Invoice Date desc. 3-Join result set of Step #2 (Only one row per supplier) to result set of Step#1. 4-Join the result set of Steps #1,#2 and #3 to SA2330 and update the payment type for each supplier.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can give you the most efficient query. You will not have any performance issue. I am very familiar with the technologies you are looking for.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have more 5 year of experience making complex SQL query in PostgreSQL, MySQL, Oracle, Vertica and SQL Server Databases, i can help you. Regards
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Marietta, United States
0,0
0
Forma de pago verificada
Miembro desde nov 8, 2018

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.