I am coding a cursor to sum up the data in a number of rows. I need to report a percentage that will be:
100 * sum/number of rows
What is the best way to get a count of the number of rows without doing a separate select? Can I include the count in my cursor declaration? Is this data included somewhere in the SQLCA?
Wherever you go, there you are - Buckaroo Banzai