CREATE TABLE [dbo].[Objects](
	[Id] [int] NOT NULL,
	[ParentId] [int] NULL,
	[Name] [nvarchar](max) COLLATE Cyrillic_General_CI_AS NOT NULL,
	[Type] [nvarchar]( 50 ) COLLATE Cyrillic_General_CI_AS NOT NULL,
 CONSTRAINT [PK_Objects] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Usage](
	[Id] [int] IDENTITY( 1 , 1 ) NOT NULL,
	[ResourceId] [int] NOT NULL,
	[ObjectId] [int] NOT NULL,
	[Created] [datetime] NOT NULL,
 CONSTRAINT [PK_Usage] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

WITH ADO ([ObjectId], [Name]) AS
(
	SELECT o.[Id], o.[Name]
	FROM [Objects] o
	WHERE o.[Name] = 'Staff'

	UNION ALL

	SELECT o.[Id], o.[Name]
	FROM [Objects] o
		INNER JOIN ADO ON o.ParentId = ADO.ObjectId
)

SELECT
	u.[ObjectId],
	COUNT(u.[ObjectId]) as Accesses,
	CONVERT(datetime, CONVERT(char( 8 ), u.[Created],  112 )) as [Date]
FROM [Usage] u LEFT JOIN ADO ON ADO.[ObjectId] = u.[ObjectId]
WHERE ResourceId =  1  AND Created BETWEEN '2008-06-01' AND '2008-10-01'
GROUP BY u.[ObjectId], CONVERT(datetime, CONVERT(char( 8 ), u.[Created],  112 ))