/* turn off run next so only the selected table is included - comment out if you want to refresh all tables */
  UPDATE [DW_RAW_CTL].[dbo].[CTL_CDC] 
  SET RUN_NEXT = 'N'
  
  /*Change the table name to include the tables you wish to force refresh*/
  UPDATE [DW_RAW_CTL].[dbo].[CTL_CDC] 
  SET NEXT_LOAD_IS_FULL_LOAD_FLAG = 'Y', RUN_NEXT = 'Y', TRUNCATE_ON_NEXT_LOAD = 'Y'
  WHERE [PERMITS_FULL_LOAD_FLAG] = 'Y'
  AND TARGET_TABLE =   'STAFF'		/* <--commenting this out = complete & full refresh/*
  --AND TARGET_TABLE IN ('STAFF', 'WIP', 'STAFFTEAM')

/*
	Then run the Windows task to refresh the table 
	(if using EDD refresh, run cch_integration.exe directly
*/