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)