DECLARE @TABLE_NAME VARCHAR(500)
DECLARE @FIELD1 NVARCHAR(255)
DECLARE @FIELD2 NVARCHAR(255)
DECLARE @FIELD3 INT
DECLARE @FIELD4 NVARCHAR(50)

DECLARE @INSERT_QUERY VARCHAR(4000)
DECLARE @INSERT_COLS VARCHAR(500)
SET @INSERT_COLS = ' (RECORD_IDENTIFIER,CHANGE_TYPE,PRO_ORDER ,UPRN) '
DECLARE @UPDATE_QUERY VARCHAR(4000)

SET @INSERT_QUERY = 'INSERT INTO '
SET @UPDATE_QUERY = 'UPDATE '


DECLARE LOCAL_CUR CURSOR  LOCAL
FOR
 SELECT 'BASIC_LAND_AND_PROPERTY_UNIT_RECORD_TYPE'+CAST(FIELD1 AS VARCHAR) TABLE_NAME,
        FIELD1, FIELD2,FIELD3,FIELD4
 FROM MASTER_TABLE
 ORDER BY FIELD1, FIELD3

OPEN LOCAL_CUR
FETCH NEXT FROM LOCAL_CUR INTO @TABLE_NAME ,@FIELD1, @FIELD2 , @FIELD3 , @FIELD4 

WHILE @@FETCH_STATUS = 0
BEGIN
	SET @INSERT_QUERY = 'INSERT INTO '
	SET @UPDATE_QUERY = 'UPDATE '

    IF @FIELD2 = 'I'
    BEGIN
      SET @INSERT_QUERY = @INSERT_QUERY + @TABLE_NAME + @INSERT_COLS +
                          ' SELECT '''+ @FIELD1+''', ''' +@FIELD2+''', ' +CAST(@FIELD3 AS VARCHAR)+', ''' +@FIELD4+''''
      PRINT @INSERT_QUERY
      -- EXEX (@INSERT_QUERY)
    END

    IF @FIELD2 = 'U'
    BEGIN

      SET @UPDATE_QUERY = @UPDATE_QUERY + @TABLE_NAME +  +
                          ' SET RECORD_IDENTIFIER = '''+ @FIELD1+''',CHANGE_TYPE = ''' +
                                 @FIELD2+''',PRO_ORDER =  ' +CAST(@FIELD3 AS VARCHAR)+',UPRN = ''' +@FIELD4+''''+
                          ' WHERE RECORD_IDENTIFIER = '''+ @FIELD1+''' AND PRO_ORDER = '+CAST(@FIELD3 AS VARCHAR)+''
      PRINT @UPDATE_QUERY
      -- EXEX (@UPDATE_QUERY)
    END

   SET @INSERT_QUERY = ''
   SET @UPDATE_QUERY = ''

  FETCH NEXT FROM LOCAL_CUR INTO @TABLE_NAME ,@FIELD1, @FIELD2 , @FIELD3 , @FIELD4 
END

CLOSE LOCAL_CUR
DEALLOCATE LOCAL_CUR