I use a lot of SELECT COUNT(*) codes to check if information is in tables for processing, especially if I am printing multiple reports within a WHILE ENDWHILE loop. Of course along with that would be IF THEN or CASE statements to determine whether to print a report. Is this the best and most efficient way to accomplish this task? I am just trying to make things faster and more efficient (and less likely to "Break" the code during processing).
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]]
