Đang Thực Hiện

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

Kỹ năng: SQL

Xem thêm: very basic, vat return, stored, SQL stored, sql stored procedure sales, vat project, stored project, edit name, basic SQL , vat calculation, sales discount project, quantity discount, edit document, edit description, magento paypal description quantity, edit title description fetched url javascript, edit template description joomla, send skype, edit sellers description ebay, sql procedure return, edit category description oscommerce, edit short description virtuemart php product file, edit price, edit meta description smarty, visual basic code inventory alert quantity

Về Bên Thuê:
( 37 nhận xét ) Cumbernauld, United Kingdom

Mã Dự Án: #1735977

Đã trao cho:

sriraj1233

Ready to complete in five mins

£20 GBP trong 0 ngày
(3 Đánh Giá)
3.6