Subject | Re: For loop or while loop inside of a stored procedure? |
---|---|
Author | Christian Mereles |
Post date | 2013-02-08T17:26:08Z |
Hi,
Loop dates within a range:
create or alter procedure SP_DATES (
INICIO date,
FINAL date)
returns (
FECHA date)
as
begin
/* Procedure Text */
Fecha = inicio;
while (Fecha < final) do
begin
Fecha = Fecha + 1;
suspend;
end
end
Regards.
-Christian-
[Non-text portions of this message have been removed]
Loop dates within a range:
create or alter procedure SP_DATES (
INICIO date,
FINAL date)
returns (
FECHA date)
as
begin
/* Procedure Text */
Fecha = inicio;
while (Fecha < final) do
begin
Fecha = Fecha + 1;
suspend;
end
end
Regards.
-Christian-
[Non-text portions of this message have been removed]