Anyone have any ideas on how I can do this with ADO?
SQL 1: Pulls top 250 records that are not in use
SELECT TOP 250 Id;
FROM MyTable;
ORDER BY Id;
WHERE EMPTY(Used_By);
INTO CURSOR MaxRecsCursor
SQL 2: Pulls the records that match the id's pulled above
SELECT *, DTOC(TranDate) + " " + TranHour + ":" + TranMin AS BkDateTime;
FROM MyTable;
WHERE ID IN;
(SELECT Id FROM MaxRecsCursor);
ORDER BY 1;
INTO CURSOR Temp1
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people