Find Jobs
Hire Freelancers

Create SQL Database and reports - repost

$10-30 USD

Completed
Posted over 10 years ago

$10-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. 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..
Project ID: 5178721

About the project

6 proposals
Remote project
Active 10 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
A proposal has not yet been provided
$30 USD in 5 days
5.0 (1 review)
4.1
4.1
6 freelancers are bidding on average $64 USD for this job
User Avatar
My past review comments can tell you that you will get quality work. Thanks ========= I can start on it right away and send the complete work to you before your deadline. Please let me the deadline for this. Awaiting your inputs. Thanks ============= If you are online we can have a quick discussion on this. waiting for you. thanks ==== Hi, Please share the text file again as I cannot download it. Let me introduce myself as an expert on SQL Server. I have worked on SQLServer 200, 2005/2008 I have also created reports using reporting services in the past. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$100 USD in 2 days
3.2 (14 reviews)
4.8
4.8
User Avatar
Hi, I have excellent work exp in sql queries, Please contact me for your work. Awaiting for your kind response. Thanks
$66 USD in 1 day
5.0 (1 review)
2.8
2.8
User Avatar
Can we talk about the project and Thanks for the project opportunity. I would very much happy to place my bid on your project and I think all your requirement meets with my skill and expertise level. First I would like to introduce myself as a professional freelancer and director of a small web design company. I have checked detail your requirements and ready to start right now. It can be done perfectly... I am available with Skype, yahoo messenger, MSN, Gtalk and phone. Send me a message to start working with you, waiting for reply. Anurag Saxena
$30 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have worked on SQL Server. I can do this for you. Only Thing is I will do it tomorrow. We will finalise the report format. Somewhere the comma is missing and somewhere the comma is added extra. I am almost done with the changes in sql.. the report is pending... Thanks Risbud Software Consultancy
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi i m expert in SQL database i can done esily and can work on imeaditly bocuase of i have done this time of before
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'll resolve the issue with the insert and create a report as per requirement. i need 1 clarification about the reporting .. you want SQL Reporting or Crystal reporting. Thanks, Ranjeet
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
window rock, United States
5.0
1
Member since Nov 29, 2013

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.