Friday, July 8, 2011

The fRiDaY File - But not on Wednesday July 6

Are you available for a conference call on Wednesday July 5 at 10:30 AM?





SELECT TOP 1
CAST ( DATEADD ( YEAR, sa_rowgenerator.row_num, '2011-07-05' ) AS DATE ) AS "Next Wednesday July 5"
FROM sa_rowgenerator ( rstart = 1, rend = 7, rstep = 1 )
WHERE DAYNAME ( "Next Wednesday July 5" ) = 'Wednesday'
ORDER BY sa_rowgenerator.row_num;

Next Wednesday July 5
'2017-07-05'



No comments: