Need to add a discount to a order table

• Dennis DeMeglio

  Old Hand

  Points: 376

  More actions

  March 14, 2005 at 9:47 am

  #362234

  I need to create a stored procedure to add a discount to an order. This stored procedure has five input parameters:

            OrderID, ProiductID, UnitPrice, Quantity, and DiscountValue.

  This stored procedure needs to display all the orders with a discount, including the ones added by the stored procedure.

   

  Any suggestions would be helpful.

   

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  March 14, 2005 at 2:11 pm

  #546933

  You should be able to do this with a SELELCT statement using CASE. 

  For exampl CASE WHEN DiscountValue = 0 THEN (UnitPrice * Quantity) ELSE ((UnitPrice * DiscountValue) * Quantity) END as Price, OrderID, ProcuctID. 

  I wasn't born stupid - I had to study.