set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO





ALTER PROCEDURE [dbo].[StpGetGood]

(
@sysCode int=0,
@Code nvarchar(100) ='',
@Barcode nvarchar(100) =''
)
AS
SELECT     StockTbl.Title, StockTbl.Code, StockTbl.BarCode, StockTbl.Type, StockTbl.FstUnit, StockTbl.SecUnit, StockTbl.UnitRate, StockTbl.OrderPoint, StockTbl.SalePrice1, 
                      StockTbl.SalePrice2, StockTbl.SalePrice3, StockTbl.SalePrice4, StockTbl.SalePrice5, StockTbl.VisitorPer, StockTbl.Comment, StockTbl.DiscontPer, StockTbl.UserPrice, 
                      StockTbl.GroupID1, StockTbl.GroupID2, StockTbl.SerialNo, StockTbl.Weight, StockTbl.GoodSyscode, StockTbl.Term, 
                      stockGroup2Tbl.VisitPercent AS GroupVisitPer
FROM         StockTbl LEFT OUTER JOIN
                      stockGroup2Tbl ON StockTbl.GroupID2 = stockGroup2Tbl.GroupId
WHERE     (StockTbl.Code = @Code) OR
                      (StockTbl.BarCode = @Barcode) OR
                      (StockTbl.GoodSyscode = @syscode)