Coming up next ...

May 2013
S
M
T
W
T
F
S
28
29
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
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 ('{1CCBBB4C-B1C0-48F2-ACF9-9C9EEDC9444C}')) 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,'5/5/2013') AND DATEPART(year,StartDateTime) = DATEPART(year,'5/5/2013') AND DATEPART(year,StartDateTime) = DATEPART(year,'5/5/2013') ORDER BY StartDateTime ASC