Date Between Problem

[baburk]

Hi all,

I want to get result for a praricular ID if all days are present.

But I am getting result if any of the day present in between the date


select StarRate, Date from vw_BasicSearch where date BETWEEN CAST('2008-06-03' AS DATETIME)
AND CAST('2008-06-05' AS DATETIME)
AND StarRate = 5
group by StarRate, Date


Result.

StarRate Date
--------------------------

5 2008-06-04 00:00:00.000
5 2008-06-05 00:00:00.000

Thanks

[code green]

But I am getting result if any of the day present in between the date

That is what the BETWEEN() function does.

I want to get result for a praricular ID if all days are present

Are you looking for a date entry of evey day covering a period. Two months in your example?

[deepuv04]

hi,
try the following query

[code=sql]
SELECT vw.StarRate, vw.Date
FROM vw_BasicSearch as vw INNER JOIN
(SELECT StarRate,Count( Distinct Date) AS DAYS
FROM vw_BasicSearch
group by code )AS T on T.StarRate = Prod.StarRate
AND DAYS = datediff(dd,GET DATE() - 3,GETDATE()) + 1
[/code]

thanks

[Delerna]

nice idea there deepuv