SQL - Obtener día hábil anterior.

SELECT DATEADD(DAY, CASE (DATEPART(WEEKDAY, GETDATE()) + @@DATEFIRST) % 7
         WHEN 1 THEN -2
         WHEN 2 THEN -3
         ELSE -1
        END, DATEDIFF(DAY, 0, GETDATE()));