Page 1 of 1

Counting the number of times a ContentFile appears

Posted: Thu Apr 10, 2008 1:40 pm
by reaperslogic
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