Posted by Erland Sommarskog on 08/08/06 14:19

Trevor Best (googlegroups@besty.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@sommarskog.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

• Next in forum: Using Union and Join in a single view
• Prev in forum: Re: SQL Server 2005 and file systems, any recommendations
• Thread view: Re: How to get last date only once all have been filled in

[Reply to this message]