delete FROM CDATA WHERE cfid in (SELECT cfid from CGLOBAL where CGLOBAL.lvisit <  '2025-05-13 00:00:00' )


SELECT MIN(lvisit) from CGLOBAL

select count(*) FROM CDATA WHERE cfid in (SELECT cfid from CGLOBAL where CGLOBAL.lvisit <  '2025-06-26 00:00:00' )






SELECT MIN(lvisit) from CGLOBAL
SELECT MAX(lvisit) from CGLOBAL

select count(*) from cglobal

select count(*) FROM CDATA WHERE cfid in (SELECT cfid from CGLOBAL where CGLOBAL.lvisit <  '2025-07-10 00:00:00' )

delete FROM CDATA WHERE cfid in (SELECT cfid from CGLOBAL where CGLOBAL.lvisit <  '2025-07-15 00:00:00' )


ROBOCOPY "fse_dev\z_cfmodMaster\tpm\scripts" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\scripts" "fse-claimEditor.js" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\views\claim\displays" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\views\claim\displays" "inc_auditTab2.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\data" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\data" "proofOfDelivery.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\data" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\data" "claimContracts.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\views\claim\displays" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\views\claim\displays" "inc_detailsTab2.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\data" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\data" "claim.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\actions" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\actions" "act_updateProofOfDelivery.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\api" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\api" "cfmod_proofOfDelivery.cfm" /NJH /NJS /NDL /NFL
ROBOCOPY "fse_dev\z_cfmodMaster\tpm\actions" "\\fseweb11\wwwroot\z_cfmodMaster\tpm\actions" "act_saveClaimEditor.cfm" /NJH /NJS /NDL /NFL


/z_cfmodMaster/tpm/scripts/fse-claimEditor.js
/z_cfmodMaster/tpm/views/claim/displays/inc_auditTab2.cfm
/z_cfmodMaster/tpm/data/proofOfDelivery.cfm
/z_cfmodMaster/tpm/data/claimContracts.cfm
/z_cfmodMaster/tpm/views/claim/displays/inc_detailsTab2.cfm
/z_cfmodMaster/tpm/data/claim.cfm
/z_cfmodMaster/tpm/actions/act_updateProofOfDelivery.cfm
/z_cfmodMaster/tpm/api/cfmod_proofOfDelivery.cfm
/z_cfmodMaster/tpm/actions/act_saveClaimEditor.cfm



truncate table fsarchive..tbl_EAI_InboundBatches;
truncate table fsarchive..tbl_TRK_GlobalErrors;
truncate table fsarchive..tbl_TRK_LibraryActivity;



select count(*) from cglobal
select count(*) from cdata

SELECT MIN(lvisit) from CGLOBAL
SELECT MAX(lvisit) from CGLOBAL

select count(*) from cglobal

select count(*) FROM CDATA WHERE cfid in (SELECT cfid from CGLOBAL where CGLOBAL.lvisit <  '2025-08-01 00:00:00' )

delete FROM CDATA WHERE cfid in (SELECT cfid from CGLOBAL where CGLOBAL.lvisit <  '2025-08-14 00:00:00' )

SELECT count(*) from CGLOBAL where CGLOBAL.lvisit <  '2025-06-30 00:00:00' 

delete from CGLOBAL where CGLOBAL.lvisit <  '2025-08-14 00:00:00'