USE COMMON 

IF OBJECTPROPERTY (OBJECT_ID('COMMON.DBO.TmpAccDup'),'ISTABLE') = 1 DROP TABLE COMMON.DBO.TmpAccDup
CREATE TABLE COMMON.DBO.TmpAccDup (TAgentName Varchar(255))		

INSERT INTO COMMON.DBO.TmpAccDup VALUES ('ALOK BACCHAWAT')
--INSERT INTO COMMON.DBO.TmpAccDup VALUES ('MOHIT TEXTILE')
--INSERT INTO COMMON.DBO.TmpAccDup VALUES ('MOHIT CREATION')


DECLARE Company_Cursor CURSOR FOR (SELECT CompCode FROM COMMON.DBO.COMPANY_DETAIL)
OPEN Company_Cursor 
DECLARE @CompCode Varchar(255) FETCH NEXT FROM Company_Cursor INTO @CompCode
WHILE (@@FETCH_STATUS <> -1) 
BEGIN 					
		DECLARE @TAccCurComp NVARCHAR(4000)
		SET @TAccCurComp='SELECT AgentCode FROM '+ @CompCode +'.dbo.AGENT_MASTER WHERE AgentName In (SELECT TAgentName FROM COMMON.DBO.TmpAccDup)'		
		DECLARE @TEMP_TABLE TABLE (AgentCode Varchar(255)) 				
		INSERT INTO @TEMP_TABLE EXEC(@TAccCurComp)
		DECLARE TAccCur CURSOR FOR SELECT * FROM @TEMP_TABLE
		OPEN TAccCur
		DECLARE @AgentCode Varchar(255) FETCH NEXT FROM TAccCur INTO @AgentCode
		WHILE (@@FETCH_STATUS <> -1) 					
		BEGIN 			
			PRINT @AgentCode
			DECLARE @TAccCurDelete NVARCHAR(4000)							
			SET @TAccCurDelete='DELETE FROM '+ @CompCode +'.dbo.AGENT_MASTER WHERE AgentCode ='+ ''''+ @AgentCode + ''''				
			EXEC (@TAccCurDelete)											
		FETCH NEXT FROM TAccCur INTO @AgentCode
		END 	
		DEALLOCATE TAccCur					
FETCH NEXT FROM Company_Cursor INTO @CompCode
END 
DEALLOCATE Company_Cursor