Find Jobs
Hire Freelancers

Create A stored Procedure in SQL

$30-100 USD

Cerrado
Publicado hace casi 18 años

$30-100 USD

Pagado a la entrega
Using the Northwind database orders table, write a single script that completes the following tasks: Create a view showing every order that was shipped to Spain. Name the destination column "DestinationSpain". Include code that checks if the view already exists. If it does, it should be dropped and re-created. Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created. Have the script display all the rows from the first view. Have the script display all the rows from the second view. Finally, have the script display the total number of orders shipped to Spain. Name the column "TotalOrdersToSpain". Using the Query Analyzer, make sure your script has no errors when it's executed. Then save and submit the .sql file. STEP THREE - Writing a Stored Procedure Complete the following tasks using the Northwind database table Order details: [login to view URL] a stored procedure named sp_insert_orderDetails that allows you to add a discount to an order. The stored procedure should accept five input parameters: OrderID, ProductID, UnitPrice, Quantity, and DiscountValue. 2. Have the stored procedure display all the orders with a discount, including the ones added by the stored procedure. After testing the stored procedure and receiving no errors, save the .sql file.
ID del proyecto: 61960

Información sobre el proyecto

24 propuestas
Proyecto remoto
Activo hace 17 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
24 freelancers están ofertando un promedio de $42 USD por este trabajo
Avatar del usuario
hi, i am interested in doing this, i am basically software eng. with 5yrs exp. vb asp java .net so u can trust me, i will deliver the project in time or even b4, with quality u expect. thanks gmh
$50 USD en 1 día
5,0 (2 comentarios)
3,3
3,3
Avatar del usuario
Hello Dear, Please check PM, Thanks
$30 USD en 1 día
5,0 (1 comentario)
3,2
3,2
Avatar del usuario
Hello Sir Is simple one, I will delivery it with in a day. More info and previous works visit my website xxxxxxxxx Select me, lets start the job. Waiting for response. With Thanks Sandesh M M
$30 USD en 0 día
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
Please check my message in your PM. Thank You.
$30 USD en 0 día
5,0 (2 comentarios)
2,6
2,6
Avatar del usuario
The solution is ready..lemme know if you want to use it...
$30 USD en 0 día
5,0 (3 comentarios)
2,3
2,3
Avatar del usuario
PLEASE CHECK PM...THANKS IN ADVANCE.
$30 USD en 0 día
2,3 (2 comentarios)
2,2
2,2
Avatar del usuario
Easy done. Can have it back in a few hours.
$50 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Did it already. Please check PMB for the file.
$40 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
can do it easily
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 8 years experience. I can have this done for you quickly.
$40 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please check PMB
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, we can do your job in no time. our bid for this job is $25
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please refer to our PM
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I assure to undertake the project provided by you and complete the same within the specified time. I guarantee to provide you complete satisfaction through dedication to the work given.
$75 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Sir, We are IFW Creations a website designing & development firm. Search “IFW Creations” on Google to know more about us. We are having a team of 22 IT professionals who are experts on Web specific technologies. We would like to understand your specific requirements properly are we are very much confident of giving you the best possible solution. We are having an experience of making more than 100 dynamic and static websites in ASP, PHP, .NET, ASP.NET, Mambo, Joomla, Delphi, Coldfusion, FLASH, DNN, PHP Nuke ETC. Please start communication. We will put one of our project managers as the in charge for your project and for regular communication with you for the daily progress reports. For payment we prefer paypal and WU. We would like to show you some samples of our work at our links at PMB if requested.
$90 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
see PMB(URGENT)
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
the task is easy. you can have it within an hour from payment.
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
We can fulfill your requirement. Contact us if interested.
$100 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir/Madam: I believe that my strong technical experience and education will make me a very competitive candidate for this project. The key strengths that I possess for success in this position include but are not limited to the following: 10 years programming experience using Powerbuilder language and Microsoft SQL Server database for both new applications and maintenance work. Very Proficient in creating queries using T-SQL Experienced in developing automated marketing campaigns that led to: Increase in product sales. Reduce in operational expense. Improve sales representatives efficiency. Led a successful conversion process from a legacy stand-alone system to client/server banking application. Problem isolation and analysis. Software quality unit testing. Application and requirement analysis. Process improvement and documentation. Technical support. Sincerely, Alberto
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir, Im Expert DBA , with 3 years experience in MS SQL please review your PMB for more details Regards George
$75 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de ICELAND
oak, Iceland
0,0
0
Miembro desde may 18, 2006

Verificación del cliente

Otros trabajos de este cliente

22007 Northwind_Stored_Procedure
N/A
¡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.