Find Jobs
Hire Freelancers

Create SQL Database and reports - repost

$10-30 USD

完了済み
投稿日: 10年以上前

$10-30 USD

完了時にお支払い
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..
プロジェクト ID: 5178721

プロジェクトについて

6個の提案
リモートプロジェクト
アクティブ 10年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
A proposal has not yet been provided
$30 USD 5日以内
5.0 (1 レビュー)
4.1
4.1
6 freelancers are bidding on average $64 USD for this job
ユーザーアバター
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 2日以内
3.2 (14 レビュー)
4.8
4.8
ユーザーアバター
Hi, I have excellent work exp in sql queries, Please contact me for your work. Awaiting for your kind response. Thanks
$66 USD 1日以内
5.0 (1 レビュー)
2.8
2.8
ユーザーアバター
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 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 2日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
window rock, United States
5.0
1
メンバー登録日:11月 29, 2013

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。