comparing two dates

[camy123]

guys justa quickie here..... how can i compare to dates to find out which one is the most recent
using datediff etc ..
cheers guys

 

[JamesLean]

DECLARE @date1 datetime,
	@date2 datetime

SET @date1 = '20050501'
SET @date2 = '20050505'

SELECT CASE WHEN @date1 > @date2 THEN @date1 ELSE @date2 END AS MaxDate

--James

 

[camy123]

cheers i was woinderinfg iff there was a datediff version but i suppose that wouldbe much longer.. thank you .