🚀 go-pugleaf

Assuming you have InterBase 7.5 or 2007, created a calculated field 
using case, then order by that field. With earlier versions of InterBase 
you'll need a stored procedure that returns a results set and you can 
order on what it returns.

aleplgr wrote:
> asdfa
> I have one 3 field's table: ClientID, Date1 and Date2, first I need to order it  by ClientID and for each ClientID order by Date1, then: 
> I have to return a table with each CliendID and if the difference between the actual Date1 and next(Date2) >30 return actual Date1 else if there is no such difference >30 return the greatest Date1 for the actual ClientID. 
> 
> next(Date2) is the Date2 that is in the next row of the actual ClientID
> I can create auxiliar tables for storing intermmediate results and I'm using EMS SQL Manager 2005, but don't know how to deal with this, any hint please
> 

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;