How to write code shortly than this for deleting the batches in vc++ ?

CRecordset recordSet(&theApp.data);

by using this recordset iam getting the records from table by sql statements here i am representing a ghantt chart in that we have batches when i select a batch and click on repeat then remaining batches after that selected batch should be deleted now i'm achieving it but it is taking a long time for execution so, i wanna modify the code shortly than this Here what i am thinking is that while deleting the batches it should be done with sql statement then in one step i can delete all batches that to be deleted it is my requirement


is there any idea's .........

actually it is regarding to Ghantt chart in this Ghantt chart we will have batches to represent the data while iam repeating a particular batch the batches after the selected batches should be deleted and the selected the batch should be replaced until the end of the date it is working fine with the above code but what i need is to reduce the code because the loop is taking long time for execution in OnDeleteWithSnap(); method what i have to do??????????

Here is my code in delete with snap....

void CGanttChartView::OnDeleteWithSnap()
{
/*
** Update delete_flag in PAS_PRM_BATCH_TRAN.
*/
if (!theApp.m_pGeneric->ExecuteSQL(GetSQLStatement(UPDATE_DELETE_FLAG,ACTIVE,sbatchNode.strPrmBatchID)))
{
theApp.m_pGeneric->ICOMMessage("Gantt Chart - 1015",MB_OK,"Cannot update delete flag","\n");
theApp.data.Rollback();
return;
}
/* }
if (!theApp.m_pGeneric->ExecuteSQL(GetSQLStatement(UPDATE_SEC_BATCH_DATES,ACTIVE,sbatchNode.strPrmBatchID)))
{
theApp.m_pGeneric->ICOMMessage("Gantt Chart - 1015",MB_OK,"Cannot update delete flag","\n");
theApp.data.Rollback();
return;
}*/

theApp.m_strDeletedBatchArr.Add(sbatchNode.strPrmBatchID);



//Get the selected batch's Start and end dates
CString sSecBatchID;
long lColNum=0;
CRecordset recordSet(&theApp.data);
if (theApp.m_pGeneric->OpenRecordSet(&recordSet,GetSQLStatement(SEC_BATCH_ID,ACTIVE,sbatchNode.strPrmBatchID)))
{
while (recordSet.IsEOF() != TRUE)
{
recordSet.GetFieldValue((short)lColNum, sSecBatchID);

if(sSecBatchID==nSecId)
{
recordSet.GetFieldValue((short)lColNum+2, m_sSimStartDate);
recordSet.GetFieldValue((short)lColNum+3, m_sSimStopDate);

}

recordSet.MoveNext();
}
}
recordSet.Close();

CRecordset CondInstructIDRecordSet(&theApp.data);

if (theApp.m_pGeneric->OpenRecordSet(&CondInstructIDRecordSet,GetSQLStatement(CONDITIONAL_INSTRUCTIONS_ID,ACTIVE,sbatchNode.strPrmBatchID)))
{
if(CondInstructIDRecordSet.IsEOF() != TRUE)
{
// Add the conditions of the deleted batch to it's previous batch
// Get the primary batch Id of the previous batch
// Clear if any conditions associated with the previous batch
// Insert the conditions to the previous batch
CRecordset ganttRecordSet(&theApp.data);
CString csMinSimStartDate;
CString csPrevBatchId;
if (theApp.m_pGeneric->OpenRecordSet(&ganttRecordSet, GetSQLStatement(GET_PREV_SIMULATOR_START_TIME,CRecordset::readOnly) ))

ganttRecordSet.GetFieldValue((short)0, csMinSimStartDate);
ganttRecordSet.Close();

if (theApp.m_pGeneric->OpenRecordSet(&ganttRecordSet, GetSQLStatement(GET_PREV_NEXT_BATCH_ID,CRecordset::readOnly,csMinSimStartDate) ))

ganttRecordSet.GetFieldValue((short)0, csPrevBatchId);
ganttRecordSet.Close();

//Delete the conditions for the previous batch
if (!DeleteConditionalInstr(csPrevBatchId))
{
MessageBox("Unable to Delete the conditions for the previous batch");
return;
}
m_sID=csPrevBatchId;
if (!CopyConditionalInstructions(sbatchNode.strPrmBatchID))
return;
}
}
// Update the Simulator_start_date and Simulator_stop_dates for the subsequent batches
m_dtSimStartDate=theApp.m_pGeneric->ConvertDateTime(DATE_TIME_USER_UPDATE,sbatchNode.sStartDate);
m_dtSimStopDate=theApp.m_pGeneric->ConvertDateTime(DATE_TIME_USER_UPDATE,sbatchNode.sEndDate);
CString csDiff=GetMovementwidth(m_dtSimStartDate);
csDiff=_T("-")+csDiff;
// Decrease the Simulator_start_date and simulator_stop_date by diff -SQL query
if(!theApp.m_pGeneric->ExecuteSQL(GetSQLStatement(UPDATE_SEC_BATCH_SIM_DATE,ACTIVE,csDiff)))
{
theApp.m_pGeneric->ICOMMessage("Batch Book - 1015",MB_OK,"Secondary Batch record","\n");
theApp.data.Rollback();
//return bRtnValue = FALSE;
}

if (!theApp.m_pGeneric->ExecuteSQL(GetSQLStatement(UPDATE_SEC_BATCH_DATES,ACTIVE,sbatchNode.strPrmBatchID)))
{
theApp.m_pGeneric->ICOMMessage("Gantt Chart - 1015",MB_OK,"Cannot update delete flag","\n");
theApp.data.Rollback();
return;
}
}