>>>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.