Sql Server 7 - Most recent date

[Guest_imported]

Hi,

I want to write query to retrieve the most recent date, such as:

SELECT Recent('2001-02-03','2001-12-12',...)

Is there a way to deal with this ?(I couldn't create a function with my Sql Server 7, is it normal ?)

Thanks

Vincent

 

[Cagliostro]

select max t.t from
(select .datediff(d,dateCol,getDate()) t..) t John Fill

ivfmd@mail.md

 

[Cagliostro]

sorry, put min instead of max John Fill

ivfmd@mail.md

 

[rajeevnandanmishra]

Hi Vincent,
John's query is going to give you correct result.
But the same result you can get just by giving this query.

SELECT MAX(myDateColumn) FROM myTable

 

[Guest_imported]

The problem is that the different date are in different tables and in different fields ...

SELECT Recent(SELECT ... FROM ... WHERE ...,
SELECT ... FROM ... WHERE ...,
...)

Vincent

 

[rajeevnandanmishra]

Hi Vincent,

Still you can use the same login in this way
------------------------------
SELECT max(myNewDateColumn) FROM (
SELECT myNewDateColumn=max(table1Date) FROM table1 WHERE ..
UNION
SELECT myNewDateColumn=max(table2Date) FROM table2 WHERE ..
UNION
SELECT myNewDateColumn=max(table3Date) FROM table3 WHERE ..
) A
------------------------------

Hope this will solve your problem!