set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [QAPower].[CITY_ALREADY_EXISTS] (@CITY_DESC VARCHAR(MAX),@RECORD_TYPE BIT,@COUNTRY_ID TINYINT,@CITY_ID TINYINT) RETURNS BIT AS BEGIN DECLARE @RESULT TINYINT IF(@RECORD_TYPE=0) SET @RESULT=(SELECT COUNT (*) FROM QAPower.HDR_CITY WHERE CITY_DESC=@CITY_DESC AND COUNTRY_ID=@COUNTRY_ID) ELSE SET @RESULT=(SELECT COUNT (*) FROM QAPower.HDR_CITY WHERE CITY_DESC=@CITY_DESC AND NOT (COUNTRY_ID=@COUNTRY_ID AND CITY_ID=@CITY_ID)) IF (@RESULT) > 0 RETURN 1 ELSE RETURN 0 RETURN 1 END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)