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 ('{4EFD385D-7C9C-4AFC-B33E-4FC846C173D6}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND DATEPART(month,StartDateTime) = DATEPART(month,'1/25/2013') AND DATEPART(year,StartDateTime) = DATEPART(year,'1/25/2013') AND DATEPART(year,StartDateTime) = DATEPART(year,'1/25/2013') ORDER BY StartDateTime ASC
-
Saturday, January 19, 2013
-
Thursday, January 24, 2013
-
Thursday, January 24, 2013
-
Sunday, January 27, 2013
|