Currency        Numeric Currency  Rate  Hash Total

AED     041     999.999999      ###########
ATS     010     999.999999      ###########
AUD     009     999.999999      ###########
BEF     014     999.999999      ###########
BHD     012     999.999999      ###########



Hi all,

 I have a report in this format. now the number oflines may grow even to
10,000.  Now each row will have its own alignment.
Also the column Hash Total is calculated using the formula ( (rate *7 ) +
numeric code );
For EG:
currency length - 15 display size - 3
This means the heading has to be 15 columns while the rows will haev 3
spaces filled with result and remaining fileld with spaces.

similarly for other columns also.
I am basically fetching the result from the Stored Procedures. I presume
that if i start doing this in my application, it will be a sure bottleneck.

Is there a way to makethis faster like writing directly from the stored
procs to a file with all alignments.

your help will be highly appreciated.

 Regards

 Ramesh Kesavanarayanan
 [EMAIL PROTECTED]
 +91-44- 811 3063 ext 2232 VNet- 42425


This e-mail and any files transmitted with it are for the sole use of the intended 
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and 
destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or 
copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

                Visit us at http://www.cognizant.com

Reply via email to