Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Rounding Max and Min for Charts

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-29 : 23:52:09
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"

   

- Advertisement -