Find Jobs
Hire Freelancers

Create SQL Database and reports

$30 USD

In Progress
Posted over 11 years ago

$30 USD

Paid on delivery
I need the following done by someone who knows SQL and can do this REALLY FAST Build a working sample of Huffman Trucking’s fleet truck maintenance database. Use the CREATE table statement to create a table for each entity for Huffman Trucking’s fleet truck maintenance database. Use the INSERT statement to populate the tables with realistic sample data, demonstrating each relationship in your entity relationship diagram. Include at least two entries for each table. Use the SELECT statement to create the following queries: • Create a simple query for each table that returns all of the columns and all of the rows for each table. • Write a query that displays each part that has been purchased by Huffman Trucking Company. For each part, also retrieve its parts catalog information from the parts catalog table and vendor information from the vendor table. • Write a query that displays all of the rows in the vehicle maintenance table. For each vehicle maintenance row, join the corresponding information from the maintenance descriptions table and vehicles table. • Write a query that displays each row in the maintenance work order table. For each row in the maintenance work order table, join the corresponding information from the maintenance description table. • Write a query that counts the number of maintenance work orders for each vehicle in the maintenance work order table. Display the vehicle column and the corresponding count of work orders for each vehicle. Use Reporting Services to design and create a report on the parts purchasing history for Huffman Trucking Company. The report should display all parts purchasing history including manufacturer and vendor information, parts catalog information, and associated parts inventory issues, and all parts inventory purchases. Format the report to present to senior management at Huffman Trucking. I HAVE THIS CODE ALREADY DONE (ATTACHED) to build the DB and the Tables.... there is something wrong with the inserts.. I NEED THIS DONE YESTERDAY... MUST BE DONE IN SQL SERVER ------ YES MUST BE DONE IN SQL SERVER AND THE REPORTS need to be done in the report designer.. I will provide everything to make it as easy as possible. I will pay $30 for the project.
Project ID: 2423786

About the project

8 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear Sir, Please find the attached file for completed working script. I can do rest of the reporting work with in one hour time Boss. please assign this job for me.I 'll do right now and give full code. Please assign this task for me I can assure 100% completion. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and five years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$30 USD in 1 day
4.9 (26 reviews)
4.4
4.4
8 freelancers are bidding on average $30 USD for this job
User Avatar
i have done this work. give me a chance and tell me when start this work
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is a simple project and I am pretty sure that I will do it.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Will be done in time and with high quality. Please contact for us to discuss further.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi !! I have good experiance of working with databases. I can do this.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 9 years of IT experience. I have gone thru your database and understood your requirement clearly. I can do this for you.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 9 years of exp with SQL server. I can confidently do this job.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NICARAGUA
Fresno, Nicaragua
5.0
3
Payment method verified
Member since Aug 21, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.