>>>Does it have to be SCAN/ENDSCAN?
>>
>>I can use DO WHILE instead, but I always prefer SCAN.
>
>Thtat's not what I had in mind. Can it be done using SQL commands?
No, how?
I used some SQL to create cursor to process. Then for each different client or carrier I need to insert data into two tables, update several tables and also produce XLS. I don't see a way of doing all this logic in SQL.
If it's not broken, fix it until it is.
My Blog