set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[STPListGoodForBuyInvoice] 

AS 
SELECT      StockTbl.GoodSyscode,StockTbl.Title
FROM         StockTbl 
WHERE     (StockTbl.Type <> 1) AND (StockTbl.Type <> 3)
ORDER BY StockTbl.Title