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
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.
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!
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
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.
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.
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
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.
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.