Database

WHERE E.Start >= @Date AND E.Start < DATEADD( d, 1, @Date )

<br />
DECLARE @FromDate datetime<br />
DECLARE @ToDate datetime<br />
<br />
SET @FromDate = (CAST(@Date AS datetime ))<br />
SET @ToDate = DATEADD( D, 1, (DATEADD(mi, -1, @FromDate )) )<br />
<br />
	SELECT	E.ID As EventID,<br />
			ET.ID As TypeID,<br />
			E.Title As EventTitle,<br />
			V.ID As VenueID,<br />
			V.[Name] As VenueName,<br />
			E.Description As EventDescription,<br />
			E.Start As EventStart,<br />
			E.Finish As EventFinish<br />
	FROM Events E<br />
	INNER JOIN Venues V<br />
	ON E.VenueID = V.ID<br />
	INNER JOIN EventTypes ET<br />
	ON E.TypeID = ET.ID<br />
	WHERE E.Start >= @FromDate<br />
	AND E.Start <= @ToDate<br />
	AND V.CityID = @CityID

WHERE DAY(E.Start)   = DAY(@Date) <br />
            AND MONTH(E.Start) = MONTH(@Date) <br />
            AND YEAR(E.Start)  = YEAR(@Date)

kindman_nb wrote:

I used Stored Procedure ..

DECLARE @startDate datetime
DECLARE @endDate datetime
 
-- note use of ISO8601 yyyyMMdd format - unambiguous
SET @startDate = CAST( CAST( @year AS varchar(4) ) + '0101' AS datetime )

-- Month is 1-based but we don't want to add anything for January
-- so we subtract 1 from the supplied month number
SET @startDate = DATEADD( m, @month - 1, @startDate )

SET @endDate = DATEADD( m, 1, @startDate )

DECLARE @startDate datetime
declare @nextdate datetime
DECLARE @endDate datetime

declare @tbl_date  table (mydate datetime)

set nocount on
SET @startDate = CAST( CAST( 2007 AS varchar(4) ) + '0101' AS datetime )

SET @startDate = DATEADD( m, 6 - 1, @startDate )

set @enddate=dateadd(m,1,@startdate)

while @startdate < @enddate
begin

--SET @nextdate = DATEADD( d, 0, @startdate )
insert into @tbl_date values (@startdate)
set @startdate=dateadd(d,1,@startdate)

end

select * from @tbl_date