set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPInvoiceDetailSeperateRowForBarCode] @SerialNo int AS SELECT StockTbl.Title AS نام, StockTbl.Code AS کد_فنی, StockTbl.BarCode AS بارکد, StockTbl.UserPrice AS قیمت_مصرف_کننده, StockTbl.SalePrice1 AS فروش1, StockTbl.SalePrice2 AS فروش2, StockTbl.SalePrice3 AS فروش3, StockTbl.SalePrice4 AS فروش4, StockTbl.SalePrice5 AS فروش5, StockTbl.Comment AS توضیحات, invoiceDetailTbl.SerialNo AS شماره_سریال FROM dbo.FunSeperateInvoiceDetailRow(@serialNo) AS FunSeperateInvoiceDetailRow_1 INNER JOIN invoiceDetailTbl ON FunSeperateInvoiceDetailRow_1.Syscode = invoiceDetailTbl.SysCode INNER JOIN StockTbl ON invoiceDetailTbl.GoodSysCode = StockTbl.GoodSyscode