Matt writes "I am using a stored procedure to return a RS for making a chart of currency rates. Problem is the chart software is not good at picking sensible Hi and Low values for the Y axis (eg. the low value in the RS might be .3520 and the high .3840 ...the chart component might have the Y axis Low at .1000 and High at .5000).You can set your own values in the chart software so here are my questions ...
a) Should I get the Max and Min values out of a seperate Stored procedure from the original SP ?
b) How can I get the SP to give me nice numbers for my max and min value .. in above example it would be nice to have max of 0.4000 and a min of 0.3500 .. (or should I do this in ASP)?
Thanks in Advance Matt Gilmour"