On 03/03/2011 05:49, Thomas Clarke wrote:

>
> The way I tackle such problems is with select stored procedure for example:

Thanks Thomas for the SP. I am not much of a SP writer though but I get
the gist. Is there anyway we can also pass the current stock to the
stored procedures and somehow loop for as many records as required into
a temp cursor which is then returned?

Thanks and regards
Bhavbhuti