How do I best add a row count in a footer with a union
Posted on 2011-03-10
I have a file that is layed out as follows: HEADER, DETAILS, FOOTER
There is a union between all 3 as the header and footer are 2 and 5 columns respectively, and the details section has 35.
I'm trying to get a row count from the details section into the footer, but can't figure out a better way than copying the entire details into the footer, doing a row count on that, and modifying the output footer to include it. My details section is over 1000 lines long and uses 76 tables. I'd rather not have it take twice as long to run if there's a better way of going about doing this.