Will Stored Procedure return random values?

[gutterline]

We have a stored procedure that returns either 10 records or 10%, depending on which is larger.  When it is imported into FW and we run a report from it, we get the same records.

I seem to recall reading that stored procedures in FW do not 'bounce' off the database on every run, that you have to manually run the procedure from within FW to refresh the data.

Is this correct?  Is there something that I may be missing with this?

TIA,
Mark