⬅ Back SQLQuery1.sql
DECLARE TAccCur CURSOR FOR SELECT AccCode FROM ACCOUNT_MASTER WHERE AccName LIKE '%ALOK BACCHAWAT%'
OPEN TAccCur
DECLARE @AccCode Varchar(255) FETCH NEXT FROM TAccCur INTO @AccCode
WHILE (@@FETCH_STATUS <> -1) 					
BEGIN 			
	PRINT @AccCode
	DECLARE @TAccCurDelete NVARCHAR(4000)							
	SET @TAccCurDelete='DELETE FROM ACCOUNT_MASTER WHERE AccCode ='+ ''''+ @AccCode + ''''				
	EXEC (@TAccCurDelete)											
FETCH NEXT FROM TAccCur INTO @AccCode
END 	

DEALLOCATE TAccCur