Counting the number of times a ContentFile appears

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
reaperslogic
Forum Newbie
Posts: 1
Joined: Thu Apr 10, 2008 1:33 pm

Counting the number of times a ContentFile appears

Post 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
Post Reply