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