Completed

Simple SQL Script Using DATEDIFF() Function

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

Skills: SQL, MySQL, Database Programming, Scripting, Microsoft SQL Server

See more: simple project vba using sql, insert xml database sql server using vbnet, upload excel database sql server using, simple form script database, sql script database changes, cms class sql script create php simple page, simple reservation script using php designer, simple login script ajax php using login scripts, oscommerce database sql script, sql script automatically create database, simple login script using ajax, using search function microsoft access, sql script backup database days, accounts database sql script, vb6 login script using sql, adding search function microsoft access database, converting microsoft sql script oracle database script, convert mysql script sql script using vbnet, simple vb script check sql database connection, simple sql script insert

About the Employer:
( 1 review ) Redington Beach, United States

Project ID: #31863247

Awarded to:

marchant2651

Hello, I work with SQL on a daily basis and can write this query for you. Let me know and I can start work on this. Thank you

$10 USD in 2 days
(0 Reviews)
0.0

17 freelancers are bidding on average $30 for this job

purplemaestro

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.

$25 USD in 1 day
(78 Reviews)
6.0
(15 Reviews)
5.5
ahmedbilal2506

Hi sir I am interested to work with you. I can provide you professional web design services. I can design for you according to your requirements. I will give you unlimited revision until you will not satisfy for your d More

$10 USD in 1 day
(29 Reviews)
4.8
nzmsaquib

Hi there: I have checked your project details and would like to help you developing the SQL script and do the nessery modifications as per you need. it will take a few hours to fix everything. I can start working on More

$50 USD in 1 day
(22 Reviews)
4.8
novikovyaroslavd

Hi there SQL King here You can check my review realted to SQL job if you hire me you can get the best result imeediately kindly hire me Thanks

$25 USD in 7 days
(4 Reviews)
2.5
sheikhnazeer3

Hello, I read your job offer regarding the SQL and I'm ready to start right away. I am also flexible with whatever budget you have. Accuracy and client's satisfaction is the top priority. Awaiting your response. Th More

$24 USD in 1 day
(2 Reviews)
2.3
ahmedkamran9

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

$25 USD in 7 days
(2 Reviews)
1.9
romannikulin5

Dear sir. Thanks for offering me a chance to get a job. I'm a new freelancer, but I've worked as a programmer at several companies for 10+ years. I fully understand what you want. I am a senior programmer and computer More

$25 USD in 1 day
(0 Reviews)
0.0
stevepol

Hello, How are you? Thank you for your job posting. I am a fullstack web developer and a PHP and Database expert. I read the description carefully and I am sure I can do the job very well. As a seasoned PHP developer More

$20 USD in 1 day
(0 Reviews)
0.0
sushilshukla1806

I have 7+ years of experience in database development and SQL working with IT giants. I have designed automated scripts for such jobs.

$25 USD in 1 day
(0 Reviews)
0.0
CavitS

Hello, I'm computer engineer and i work as software developer. I experienced MS Sql Server, Sql, C# and .NET. I can handle this issue for you.

$25 USD in 2 days
(0 Reviews)
0.0
John2580

Dear Hiring Manager, At first, take my sincere respect. I have gone through your project details and I can solve your problem within 2 hours as I have experience on complex and dynamic queries. Whatever, I am a profes More

$30 USD in 1 day
(0 Reviews)
0.0
sajjadtaghvaeifr

Hi, I hope you are doing fine. I have almost 3 years of experience in PHP, Laravel, Javascript, HTML, CSS, and etc. I have done many projects in MVC, OOP, Laravel, Javascript vanilia, Jquery, My SQL, Bootstrap. I'm int More

$100 USD in 7 days
(0 Reviews)
0.0
roxystar

Hi, I have more than 10 year experience working with SQL server. I can do this within time [login to view URL] me a chance and you will not be regret

$25 USD in 2 days
(0 Reviews)
0.0
imanolie

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

$30 USD in 1 day
(0 Reviews)
0.0
chokisl

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

$25 USD in 1 day
(0 Reviews)
0.0