set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go















ALTER PROCEDURE [dbo].[STPListGoodForSellInvoice] 

AS 

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

return