小时分组
select count(0),convert(varchar(13),CreatedDate,120) from
quote_cn.dbo.activityleads group by convert(varchar(13),CreatedDate,120)
select c.import_Date,b.* from activityleads c(nolock),
Active_CampaignCode_Logic b(nolock)
where
c.import_date >= convert(datetime,'01-11-2014',105)
and c.import_date <= convert(datetime,'12-11-2014',105)
and c.channel='DTC'
and
c.campaign_code =b.code
and c.campaign_code='bhy'
and isnull(c.channel,'')<>''
c.import_date >= convert(datetime,'2014-11-13 00:00:00')
and c.import_date <= convert(datetime,'2014-11-13 23:00:00')
select count(0),convert(varchar(13),CreatedDate,120) from
quote_cn.dbo.activityleads group by convert(varchar(13),CreatedDate,120)
select c.import_Date,b.* from activityleads c(nolock),
Active_CampaignCode_Logic b(nolock)
where
c.import_date >= convert(datetime,'01-11-2014',105)
and c.import_date <= convert(datetime,'12-11-2014',105)
and c.channel='DTC'
and
c.campaign_code =b.code
and c.campaign_code='bhy'
and isnull(c.channel,'')<>''
c.import_date >= convert(datetime,'2014-11-13 00:00:00')
and c.import_date <= convert(datetime,'2014-11-13 23:00:00')