Find Jobs
Hire Freelancers

Create SQL Database and reports

$30 USD

En curso
Publicado hace más de 11 años

$30 USD

Pagado a la 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. 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.
ID del proyecto: 2423786

Información sobre el proyecto

8 propuestas
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
4,9 (26 comentarios)
4,4
4,4
8 freelancers están ofertando un promedio de $30 USD por este trabajo
Avatar del usuario
i have done this work. give me a chance and tell me when start this work
$30 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This is a simple project and I am pretty sure that I will do it.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Will be done in time and with high quality. Please contact for us to discuss further.
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi !! I have good experiance of working with databases. I can do this.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 9 years of IT experience. I have gone thru your database and understood your requirement clearly. I can do this for you.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I have 9 years of exp with SQL server. I can confidently do this job.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NICARAGUA
Fresno, Nicaragua
5,0
3
Forma de pago verificada
Miembro desde ago 21, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.