Calendar

sql: select ItemID,Title,SourceURL,SourceURLPopWin,null as SubTitle,null as TeaserText,RelatedURL,RelatedURLPopWin,c.DetailURL, Subtitle,StartDateTime,StopDateTime,cd.ChannelID FROM ChannelData cd, Channel c WHERE (cd.ChannelID IN ('{1BE0DF13-7B4F-47BF-B10E-6306300038E0}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND (('4/20/2011' BETWEEN Cast(Left(StartDateTime,11) AS DateTime) AND IsNull(StopDateTime,DateAdd(day,1,StartDateTime))) OR (Cast(Left(StartDateTime,11) AS DateTime) = '4/20/2011')) AND DATEPART(month,StartDateTime) = DATEPART(month,'4/20/2011') AND DATEPART(year,StartDateTime) = DATEPART(year,'4/20/2011') ORDER BY StartDateTime ASC