set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER PROCEDURE [dbo].[STPListInvoiceDetailTermPrint] 
	@InvoiceSerial int
AS




SELECT     Term AS نحوه, SUM((UnitRate * Fee * Quantity) * (1 - DiscountPercent)) AS مبلغ
FROM         invoiceDetailTbl
GROUP BY Term, FK_InvoiceSysCode
HAVING      (FK_InvoiceSysCode = @InvoiceSerial)