Database

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1159.

DECLARE Cur_1 Cursor LOCAL FOR
  Select col1,col2,col3 from table1
OPEN Cur_1
FETCH NEXT FROM  Cur_1
	INTO @col1,@col2,@col3

	WHILE @@FETCH_STATUS = 0 
	BEGIN
			
	    DELETE FROM FROM TableA Where match with @col1,@col2,@col3
	    DELETE FROM FROM TableB Where match with @col1,@col2,@col3

            DECLARE Cur_2 LOCAL FOR		
	     Select * from table2 Where match with @col1,@col2,@col3
		 OPEN Cur_2
		 FETCH NEXT FROM  Cur_2

   		 WHILE @@FETCH_STATUS = 0 
		 BEGIN
BEGIN TRAN						
			INSERT INTO TableB (data from Cur_2 & Cur_1)
						
		    FETCH NEXT FROM  Cur_2
		 END
		 CLOSE Cur_2
		 DEALLOCATE Cur_2					
			
	    INSERT INTO TableA (data fromCur_1)
			
	    IF @@ERROR = 0
		COMMIT TRAN
	    ELSE
		ROLLBACK TRAN

 	    FETCH NEXT FROM  Cur_1
		INTO @col1,@col2,@col3
	END

	CLOSE	Cur_1
	DEALLOCATE Cur_1