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