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