Käynnissä

edit very basic stored procerudre

This project must be complete within 20 mins, send skype name.

I need to add a very basic calculation to a stored procedure:

I need to edit it to do a calucation on the value it returns as "DicsountAmount". It should do this:

DiscountAmount = (Line Discount Amount / (Amount + Line Discount Amount))*100)

Here is the SP:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[GetMyOrderItems]

(@OrderNumber VarChar(20))

AS

SELECT [No_] AS ItemCode, Description AS ItemDescription, Quantity, [Unit Price] AS UnitCost,

[Outstanding Amount] AS OutstandingAmount, [VAT %] As VatRate, [Line Discount Amount] As DiscountAmount,

Amount, [Amount Including VAT] As AmountIncVAT

FROM [Loxley Colour$Sales line]

WHERE [Document No_] = @OrderNumber

RETURN

Taidot: SQL

Näytä lisää: very basic, vat return, stored, sql stored, sql stored procedure sales, vat project, stored project, edit name, basic sql, vat calculation, sales discount project, edit description, edit template description joomla, send skype, edit sellers description ebay, sql procedure return, edit category description oscommerce, edit price, edit meta description smarty, sql stored procedure

About the Employer:
( 37 reviews ) Cumbernauld, United Kingdom

Projektin tunnus: #1735977

Myönnetty käyttäjälle:

sriraj1233

Ready to complete in five mins

20 £ GBP 0 päivässä
(3 arvostelua)
3.6