Muthu schrieb am 26.05.2010 um 19:45:48 (-0000):

> I have a Stored Procedure, which takes startdate and endate as input
> parameters and executes fine and returns values.
>
> I have written another SP that use the existin SP in a loop and get
> results for given number of days. But it is just returning one row.

It might be the correct result. Can't tell without the rest of your
setup.

I suggest you eliminate everything from your SP that is not relevant to
the problem, leaving in only the relevant parameters, like STARTDATE,
ENDDATE, REPORTSTARTDATE and REPORTENDDATE.

--
Michael Ludwig