Find last sunday

by 
SELECT
 DATEADD(day,DATEDIFF(day,'19000107',DATEADD(month,DATEDIFF(MONTH,0,GETDATE() /*YourValuehere*/),30))/7*7,'19000107')

Edit: A correct, final, working answer from my colleague.

More Related Contents:

  1. How to Join to first row
  2. Pivot using SQL Server 2000
  3. SQL where clause odd behavior [closed]
  4. How do I obtain a Query Execution Plan in SQL Server?
  5. How do I escape a single quote in SQL Server?
  6. Simple way to transpose columns and rows in SQL?
  7. Only inserting a row if it’s not already there
  8. Unpivot with column name
  9. Selecting data from two different servers in SQL Server
  10. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  11. SQL JOIN vs IN performance?
  12. Most efficient way in SQL Server to get date from date+time?
  13. Convert varchar into datetime in SQL Server
  14. TSQL Pivot without aggregate function
  15. How to generate a range of dates in SQL Server
  16. SQL RANK() versus ROW_NUMBER()
  17. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  18. How do I delete from multiple tables using INNER JOIN in SQL server
  19. Check if a row exists, otherwise insert
  20. SQL : BETWEEN vs =
  21. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  22. How do I perform a GROUP BY on an aliased column in SQL Server?
  23. How do I make a composite key with SQL Server Management Studio?
  24. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  25. TransactSQL to run another TransactSQL script
  26. How can I generate a temporary table filled with dates in SQL Server 2000?
  27. Getting Dates between a range of dates
  28. WHERE IS NULL, IS NOT NULL or NO WHERE clause depending on SQL Server parameter value
  29. SUM total time in SQL Server [duplicate]
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment