I have stored procedure that takes a from and to date parameters.
I want to execute the stored procedure in automatic loop - incrementing the To date by 1 until the specified end date is reached
EXEC dbo.spUpdateTran '01/01/2004',01/02/2004
End date = 12/31/2004
Once the first exec is complete then would automatically exceute
EXEC dbo.spUpdateTran '01/01/2004',01/03/2004 .. and so on until end date 12/31/2004 is reached
how would I do this?