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