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