How to get last date only once all have been filled in

[Trevor Best]

I want to be able to return the last date, e.g.

(select Max(DateColumn) From Table)

However if any of the DateColumn fields are null I want to return a
null, is there a simple way to do this?

[Erland Sommarskog]

Re: How to get last date only once all have been filled in

Trevor Best (googlegroups@b esty.org.uk) writes:

I want to be able to return the last date, e.g.
>
(select Max(DateColumn) From Table)
>
However if any of the DateColumn fields are null I want to return a
null, is there a simple way to do this?

SELECT CASE WHEN EXISTS (SELECT * FROM tbl WHERE DateColumn IS NULL)
THEN NULL
ELSE MAX(DateColumn)
FROM tbl


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Trevor Best]

Re: How to get last date only once all have been filled in

thanks