Posted By: jerryiii (Vsude dobre, v CR nejhur) on 'CZdatabases'
Title:     Re: Jeste jednou
Date:      Tue Jun 19 12:03:19 2001

Tak sem to vyresil :)) na zacatku si vezmu kolik jich bylo otevreno pres 
pulnoc:

select count(*) from request where [created] < '20010326' and [accessed] > 
'20010326'

No a pote proste budu pricitat:

select [created] as [time], 1 as [con] from request where [created] >= 
'20010326' and [created] < '20010327' 

union

select [accessed] as [time], -1 as [con] from request where [accessed] >= 
'20010326' and [accessed] < '20010327' 

order by [time] asc, [con] desc

Ta -1 mi jeden request ukonci :) a vysledne hodnoty vyhodim na graf :) pohoda 
... zas tak blbej nejsem :)

          Jerry III

Enough said ...
http://jerryiii.home.sprynet.com/mica/index.htm

Search the boards