Find Jobs
Hire Freelancers

Create SQL Database and reports - repost

$10-30 USD

Concluído
Publicado há mais de 10 anos

$10-30 USD

Pago na entrega
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 do Projeto: 5178721

Sobre o projeto

6 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
A proposal has not yet been provided
$30 USD em 5 dias
5,0 (1 avaliação)
4,1
4,1
6 freelancers estão ofertando em média $64 USD for esse trabalho
Avatar do Usuário
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 em 2 dias
3,2 (14 avaliações)
4,8
4,8
Avatar do Usuário
Hi, I have excellent work exp in sql queries, Please contact me for your work. Awaiting for your kind response. Thanks
$66 USD em 1 dia
5,0 (1 avaliação)
2,8
2,8
Avatar do Usuário
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 em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 2 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
window rock, United States
5,0
1
Membro desde nov. 29, 2013

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.