SQL Server Query Statement Get Last Previous Working Day
SELECT DATEADD ( DAY , CASE DATENAME ( WEEKDAY , GETDATE ()) WHEN 'Sunday' THEN -2 WHEN 'Monday' THEN -3 ELSE -1 END , DATEDIFF ( DAY , 0 , GETDATE ()))