Counting the number of times a ContentFile appears
Posted: Thu Apr 10, 2008 1:40 pm
I'm trying to figure out how many times a specific ContentFile appears, within a specifc date range.
A monthly date range will be used: 01-01-2008 - 01-31-2008.
SELECT DISTINCT ContentFile COUNT FROM ContentLog shows the individual content files that appear within the logs.
Schema:
CREATE TABLE [ContentLog]
( [DeviceName] [nvarchar](50) NULL,
[DeviceAddress] [nvarchar](20) NULL,
[StartTime] [nvarchar](25) NULL,
[EndTime] [nvarchar](25) NULL,
[Running] [nvarchar](25) NULL,
[DSP] [nvarchar](50) NULL,
[ContentOrZone] [nvarchar](10) NULL,
[ZoneName] [nvarchar](50) NULL,
[ContentFile] [nvarchar](256) NULL)
Thanks for any help you can give.
RL
A monthly date range will be used: 01-01-2008 - 01-31-2008.
SELECT DISTINCT ContentFile COUNT FROM ContentLog shows the individual content files that appear within the logs.
Schema:
CREATE TABLE [ContentLog]
( [DeviceName] [nvarchar](50) NULL,
[DeviceAddress] [nvarchar](20) NULL,
[StartTime] [nvarchar](25) NULL,
[EndTime] [nvarchar](25) NULL,
[Running] [nvarchar](25) NULL,
[DSP] [nvarchar](50) NULL,
[ContentOrZone] [nvarchar](10) NULL,
[ZoneName] [nvarchar](50) NULL,
[ContentFile] [nvarchar](256) NULL)
Thanks for any help you can give.
RL