set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go







create PROCEDURE [dbo].[StpListBarcodeForPrint]
AS
SELECT     BarcodeTbl.GoodCode AS کدکالا, BarcodeTbl.Field1 AS فیلد1, BarcodeTbl.Field2 AS فیلد2, StockTbl.Title AS شرح, StockTbl.Code AS کدفنی, 
                      StockTbl.BarCode AS بارکد, StockTbl.FstUnit AS واحد1, StockTbl.SecUnit AS واحد2, StockTbl.UnitRate AS [نسبت واحد], StockTbl.SalePrice1 AS فروش1, 
                      StockTbl.SalePrice2 AS فروش2, StockTbl.SalePrice3 AS فروش3, StockTbl.SalePrice4 AS فروش4, StockTbl.SalePrice5 AS فروش5, 
                      StockTbl.Comment AS توضیحات, StockTbl.GroupID1 AS گروه1, StockTbl.GroupID2 AS گروه2, StockTbl.Term AS شرایط
FROM         BarcodeTbl LEFT OUTER JOIN
                      StockTbl ON BarcodeTbl.GoodCode = StockTbl.GoodSyscode RIGHT OUTER JOIN
                      dbo.FunBarcodeQuantitySeperator() AS FunBarcodeQuantitySeperator_1 ON BarcodeTbl.GoodCode = FunBarcodeQuantitySeperator_1.Syscode