LOOP
   RS = sqlExecute("usp_ExportGetWork")
   SET strTask = RS("TASK")
   SET strPK = RS("PK_ID")
   SET strCallBackSP = RS("CallBackSP")
   IF strTask = "DONE" BREAK
   SWITCH strTask
       CASE "CUSTOMER"
           CALL API_CUSTOMER_CREATE(RS("CUST_ID"), RS("CUST_NAME"), ...)
       CASE "ORDER"
           CALL EDI_ORDER_CREATE(RS("ORDER_ID"), RS("ORDER_DATE"), RS("CUST_ID"), ...)
       CASE ....
    END SWITCH
   RS = sqlExecute(strCallBackSP, intErrorNo, strErrorMsg)
END LOOP

SELECT TOP 1 @CustID = CUST_ID
FROM CUSTOMERS
WHERE CustStatus = 'NEW'

IF @@ROWCOUNT = 1
BEGIN
   UPDATE CUSTOMERS
   SET CustStatus = 'EXPORTING'
   WHERE CUST_ID = @CustID 

   SELECT [TASK]='CUSTOMER', [KP_ID]=CUST_ID, [CallBackSP]='usp_CustomerExportUpdate',
          CUST_ID, CUST_NAME, ...
   FROM CUSTOMERS
   WHERE CUST_ID = @CustID 
   GOTO MyExit
END

SELECT TOP 1 @OrderID = ORDER_ID
FROM ORDERS
WHERE OrderStatus = 'NEW'
IF @@ROWCOUNT = 1
BEGIN
    ...

CREATE TABLE [dbo].[orders_processing_task](
	[orders_processing_task_id] [int] IDENTITY(1,1) NOT NULL,
	[process_descr] nvarchar(255) NOT NULL,
	[process_sproc] nvarchar(255) NOT NULL,
	[process_sproc_parms] nvarchar(255) NOT NULL,
	[process_sproc_parms_xml] xml NOT NULL,
	[process_ordinal_position] [int] NULL,
	[process_state] [int] NULL,
	[process_succeededYesNo] [bit] NOT NULL
) ON [PRIMARY]

INSERT INTO dbo.orders_processing_task
        ( process_descr ,
          process_sproc ,
          process_sproc_parms ,
          process_sproc_parms_xml ,
          process_ordinal_position ,
          process_state ,
          process_succeededYesNo
        )
VALUES  ( N'ORDER' , -- process_descr - nvarchar(255)
          N'usp_ExportUpdate' , -- process_sproc - nvarchar(255)
          N'' , -- process_sproc_parms - nvarchar(255)
          '<?xml version="1.0" encoding="utf-8"?><Parms><JobType>ORDER</JobType></Parms>' , 
          1 , -- process_ordinal_position - int
          1 , -- process_state - int
          1  -- process_succeededYesNo - bit
        )
        
SELECT * FROM dbo.orders_processing_task

BEGIN TRANSACTION

-- Get records for the batch
INSERT INTO @TEMP
SELECT @CustID = CUST_ID
FROM CUSTOMERS
WHERE CustStatus = 'NEW'

-- Flag them as done
UPDATE U
SET CustStatus = 'EXPORTED'
FROM CUSTOMERS AS U
     JOIN @Temp AS T
         ON T.CUST_ID = U.CUST_ID

-- Select the data
i.e. to pass to Service Broker, or my App (but SET based), or something similar
SELECT Col1, Col2, ...
FROM CUSTOMERS AS U
     JOIN @Temp AS T
         ON T.CUST_ID = U.CUST_ID

COMMIT

UPDATE LOCAL
SET Status = "ON-REMOTE"
FROM CUSTOMERS AS LOCAL
   JOIN RemoteTargetSystem.CUSTOMERS AS REMOTE
       ON REMOTE.CUST_ID = LOCAL.CUST_ID
WHERE LOCAL.CustStatus = 'EXPORTED'

BEGIN TRANSACTION

SELECT @NextBatch = MAX(BatchNo)+1 FROM CUSTOMERS

-- Assign Customer Records to the Batch
UPDATE U
SET CustStatus = 'EXPORTED',
    BatchNo = @NextBatch 
FROM CUSTOMERS AS U
WHERE CustStatus = 'NEW'

COMMIT

-- Select the data
i.e. to pass to Service Broker, or my App (but SET based), or something similar
SELECT Col1, Col2, ...
FROM CUSTOMERS
WHERE BatchNo = @NextBatch 

<yaks>
  <Customer CustomerID="134">
    <CustomerName><![CDATA[Kumboodle]]></CustomerName>
    <Orders>
       <Order OrderID="1" Expedite="1">
          <Item ItemID="1" UOM="1 ea">
          <Item ItemID="2" UOM="4 ct">
       </Order>
    </Orders>
  </Customer>
  <Customer CustomerID="135">
    <CustomerName><![CDATA[Cuptiz]]></CustomerName>
    <Orders>
       <Order OrderID="1" Expedite="1">
          <Item ItemID="1" UOM="1 ea">
          <Item ItemID="2" UOM="4 ct">
       </Order>
    </Orders>
  </Customer>  
<yaks>