:-)Thanks. Here it is:

if (object_id('tempdb..#Astime') is not null) drop table #Astime

create table #Astime (ResourceId smallint, Site smallint,

DateKey int, TimeKey int, EventType smallint)

insert into #Astime

select 1, 1, 20100901, 80010,2

union

select 1, 1, 20100901, 113001,3

union

select 1, 1, 20100901, 122014,2

union

select 1, 1, 20100901, 153223,3

union

select 1, 1, 20100901, 153814,2

union

select 1, 1, 20100901, 161503,3

union

select 1, 1, 20100902, 80010,2

union

select 1, 1, 20100902, 122014,2

union

select 1, 1, 20100902, 153223,3

union

select 1, 1, 20100902, 153814,2

union

select 1, 1, 20100902, 161510,3

union

select 2, 1, 20100901, 80015,2

union

select 2, 1, 20100901, 113001,3

union

select 2, 1, 20100901, 122014,2

union

select 2, 1, 20100901, 153223,3

union

select 2, 1, 20100901, 153814,2

union

select 2, 1, 20100901, 161523,3

union

select 2, 1, 20100902, 80010,2

union

select 2, 1, 20100902, 122014,2

union

select 2, 1, 20100902, 153223,3

union

select 2, 1, 20100902, 153814,2

union

select 2, 1, 20100902, 161520,3

select * from #Astime