Microsoft SQL database has a table, “Manufacture”, that has two columns: “BatchCloseDate” and “ShipDate”.
The script will calculate the date difference (in days) between BatchCloseDate and ShipDate for all rows in the Manufacture table, and then calculate the percentage of rows in which the date difference is more than 10 days for a given month. Do not include any row with ShipDate = NULL.
I do not mind having to manually input month start date and month end date if that is easier to do.
Example: There are 100 rows with a ShipDate in January. Of those rows, 5 rows had date differences of more than 5. On running the script, the percentage displayed is 95%.
17 freelancers are bidding on average $30 for this job
Hi. Hope you are doing well. I have high level expertise in SQL Server. I have read the query requirements and can write that query very quickly. Will provide you top quality work for sure. I can start right now.
Hi, I’m a UK based developer with over 17 years of experience in databases including oracle and SQL server. I can certainly help you in this task. I’m looking forward to work with you on this project. Regards, Kam
Hi there, I can provide this within 2h if you'd give me a sample data to test my script. If you agree, I can start working on it and you can award me the project only after I give you the solution. Thanks, Ioan
Hello Sir, I am Microsoft certified SQL Professional since 2011, with more than 15 years of experience in MS SQL This is an easy task for me, I can immediately send to you a test script. Best Regards, Yanko Yankov