ELSE PRINT ' It is a weekday . '
IF DATEPART ( dw , GETDATE ( ) ) = 7 OR DATEPART ( dw , GETDATE ( ) ) = 1 PRINT ' It is the weekend . '
ELSE PRINT ' DATEPART is a weekday . '
IF DATEPART ( dw , GETDATE ( ) ) = 7 OR DATEPART ( dw , GETDATE ( ) ) = 1 PRINT ' It is the weekend . '