Home Forums SQL Server 2005 Administering select query RE: select query
vivekswamy85
SSC Enthusiast
Points: 179
More actions
September 22, 2012 at 9:19 pm
#1541134
It can also be done using Pivot Concept...very simple
SELECT Max(date)
FROM (SELECT date
FROM (SELECT date1,
date2,
date3
FROM sample) AS X
UNPIVOT (date
FOR sample IN (date1,
date3)) AS unpivoty) AS Z