set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



ALTER PROCEDURE [dbo].[STPIsGoodExist] 
		@GoodTitle	nvarchar(1000),
		@GoodCode int=0
AS
if @GoodCode<>0 
	if exists(SELECT     GoodSyscode
	FROM         StockTbl
	WHERE     (Title = @GoodTitle) AND (GoodSyscode <> @GoodCode)) 	return 1 else return 0
else
	if exists(SELECT     GoodSyscode
	FROM         StockTbl
	WHERE     (Title = @GoodTitle) ) 	return 1 else return 0