DECLARE TAccCur CURSOR FOR SELECT AgentCode FROM AGENT_MASTER WHERE AgentName LIKE 'VASANT SAILOR' 
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 AGENT_MASTER WHERE AgentCode ='+ ''''+ @AccCode + ''''				
	EXEC (@TAccCurDelete)											
FETCH NEXT FROM TAccCur INTO @AccCode
END 	

DEALLOCATE TAccCur