loop between 2 datetime field values

Hi how can i loop between 2 datetime value ex:


i have this stored procedure:

@onde CHAR(100) = NULL,
@quandoinicio CHAR(100) = NULL,
@quandofim CHAR(100) = NULL,
@quantominimo CHAR(100) = NULL,
@quantomaximo CHAR(100) = NULL,
@quartos CHAR(100) = NULL,
@pessoas CHAR(100) = NULL,
@tipo CHAR(100) = NULL,
@rcama CHAR(100) = NULL,
@rbanho CHAR(100) = NULL,
@limpeza CHAR(100) = NULL,
@maqloica CHAR(100) = NULL,
@maqroupa CHAR(100) = NULL,
@arcon CHAR(100) = NULL,
@satcabo CHAR(100) = NULL,
@internet CHAR(100) = NULL,
@barbecue CHAR(100) = NULL,
@formpesqavancadabut CHAR(100) = NULL
AS
BEGIN
SET NOCOUNT ON;

SELECT distinct
cod_casa,destino,data_activo,tipo,pessoas,localidade,img_1,img_2 ,img_3,
img_4,data_act, certif,valor_voto,n_voto

FROM
pesq_1_com_feedback
WHERE
((@onde IS NULL) OR (localidade = @onde))
AND ((@quandoinicio IS NULL) OR (inicio >= @quandoinicio))
AND ((@quandofim IS NULL) OR (fim <= @quandofim))
AND ((@quantominimo IS NULL) OR (preco > @quantominimo ))
AND ((@quantomaximo IS NULL) OR (preco < @quantomaximo ))
AND ((@quartos IS NULL) OR (quartos = @quartos ))
AND ((@pessoas IS NULL) OR (pessoas = @pessoas ))
AND ((@tipo IS NULL) OR (tipo = @tipo ))
AND ((@rcama IS NULL) OR (roupascama = @rcama ))

AND ((@rbanho IS NULL) OR (roupasbanho = @rbanho ))
AND ((@limpeza IS NULL) OR (limpeza = @limpeza ))
AND ((@maqloica IS NULL) OR (mlavaloica = @maqloica ))
AND ((@maqroupa IS NULL) OR (mlavaroupa = @maqroupa ))
AND ((@arcon IS NULL) OR (ar_condicionado = @arcon))
AND ((@satcabo IS NULL) OR (satcabo = @satcabo))
AND ((@internet IS NULL) OR (internet = @internet))
AND ((@barbecue IS NULL) OR (barbecue = @barbecue))

i have availibility calendar that have rows with
startdate and end date:

select startdate,enddate where cod_casa="record from the first select"
and livre=0

it is possible to loop between startdate to enddate?

as i do do while not rs2.eof
for k = cdate(rs2("startdate")) to cdate(rs2("enddate"))

i'm not experienced, but this loops in asp become slow and i think
treres a way to do it in sql server

led
It is not clear what you are trying to achive, I mean, why loop? Can you
post sample data to be tested?

"led" wrote in message

> Hi how can i loop between 2 datetime value ex:
>
>
> i have this stored procedure:
>
> @onde CHAR(100) = NULL,
> @quandoinicio CHAR(100) = NULL,
> @quandofim CHAR(100) = NULL,
> @quantominimo CHAR(100) = NULL,
> @quantomaximo CHAR(100) = NULL,
> @quartos CHAR(100) = NULL,
> @pessoas CHAR(100) = NULL,
> @tipo CHAR(100) = NULL,
> @rcama CHAR(100) = NULL,
> @rbanho CHAR(100) = NULL,
> @limpeza CHAR(100) = NULL,
> @maqloica CHAR(100) = NULL,
> @maqroupa CHAR(100) = NULL,
> @arcon CHAR(100) = NULL,
> @satcabo CHAR(100) = NULL,
> @internet CHAR(100) = NULL,
> @barbecue CHAR(100) = NULL,
> @formpesqavancadabut CHAR(100) = NULL
> AS
> BEGIN
> SET NOCOUNT ON;
>
> SELECT distinct
> cod_casa,destino,data_activo,tipo,pessoas,localidade,img_1,img_2 ,img_3,
> img_4,data_act, certif,valor_voto,n_voto
>
> FROM
> pesq_1_com_feedback
> WHERE
> ((@onde IS NULL) OR (localidade = @onde))
> AND ((@quandoinicio IS NULL) OR (inicio >= @quandoinicio))
> AND ((@quandofim IS NULL) OR (fim <= @quandofim))
> AND ((@quantominimo IS NULL) OR (preco > @quantominimo ))
> AND ((@quantomaximo IS NULL) OR (preco < @quantomaximo ))
> AND ((@quartos IS NULL) OR (quartos = @quartos ))
> AND ((@pessoas IS NULL) OR (pessoas = @pessoas ))
> AND ((@tipo IS NULL) OR (tipo = @tipo ))
> AND ((@rcama IS NULL) OR (roupascama = @rcama ))
>
> AND ((@rbanho IS NULL) OR (roupasbanho = @rbanho ))
> AND ((@limpeza IS NULL) OR (limpeza = @limpeza ))
> AND ((@maqloica IS NULL) OR (mlavaloica = @maqloica ))
> AND ((@maqroupa IS NULL) OR (mlavaroupa = @maqroupa ))
> AND ((@arcon IS NULL) OR (ar_condicionado = @arcon))
> AND ((@satcabo IS NULL) OR (satcabo = @satcabo))
> AND ((@internet IS NULL) OR (internet = @internet))
> AND ((@barbecue IS NULL) OR (barbecue = @barbecue))
>
> i have availibility calendar that have rows with
> startdate and end date:
>
> select startdate,enddate where cod_casa="record from the first select" and
> livre=0
>
> it is possible to loop between startdate to enddate?
>
> as i do do while not rs2.eof
> for k = cdate(rs2("startdate")) to cdate(rs2("enddate"))
>
> i'm not experienced, but this loops in asp become slow and i think treres
> a way to do it in sql server
>