SELECT WHEN week_val =1 THEN (SELECT TOP 1 hour_val FROM TableName WHERE week_val <> 1)
       ELSE  hour_val
       END
FROM  TableName