Example - Sync Process - Check Progress

select Process_ID,RecordCount = count(*)
from dbo.CLARCreditMemoDoc
group by Process_ID
order by Process_ID

select Process_ID,Mfsql_Process_Batch,RecordCount = count(*)
from dbo.CLARCreditMemoDoc
group by Process_ID,Mfsql_Process_Batch
order by Process_ID,Mfsql_Process_Batch

select Process_ID,Mfsql_Process_Batch,Update_ID,RecordCount = count(*)
from dbo.CLARCreditMemoDoc
group by Process_ID,Mfsql_Process_Batch,Update_ID
order by Process_ID,Mfsql_Process_Batch,Update_ID

SELECT * FROM dbo.CLARCreditMemoDoc  WHERE Mfsql_Process_Batch = 84