RxRecordset rst;
        sql="select * from A";
    rst.Open(sql);
    while(!rst.end())
    {
        int Id=atoi(rst.GetFieldValue("Id"));
        RxRecordset rs;
        sql.Format("select top 100 * from %s where Id >= %d and Id<%d",B,Id*100,Id*100+99);
        rs.Open(sql);
        while(!rs.isend())
        {
           rs.MoveNext();
        }
        rst.MoveNext();
    }