Get the week start date and week end date from week number

by

You can find the day of week and do a date add on days to get the start and end dates..

DATEADD(dd, -(DATEPART(dw, WeddingDate)-1), WeddingDate) [WeekStart]

DATEADD(dd, 7-(DATEPART(dw, WeddingDate)), WeddingDate) [WeekEnd]

You probably also want to look at stripping off the time from the date as well though.

More Related Contents:

  1. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  2. Insert results of a stored procedure into a temporary table
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. Best approach to remove time part of datetime in SQL Server
  5. Select top 10 records for each category
  6. The multi-part identifier could not be bound
  7. How important is the order of columns in indexes?
  8. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  9. SQL Server – transactions roll back on error?
  10. Difference between a User and a Login in SQL Server
  11. Fastest way to update 120 Million records
  12. Is it possible to select sql server data using column ordinal position
  13. How to find current transaction level?
  14. How to insert multiple records and get the identity value?
  15. How to Replace Multiple Characters in SQL?
  16. How can a LEFT OUTER JOIN return more records than exist in the left table?
  17. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  18. Dynamic SQL to generate column names?
  19. SQL comma-separated row with Group By clause
  20. Column name or number of supplied values does not match table definition
  21. SQL Server PIVOT perhaps?
  22. How to find consecutive rows based on the value of a column?
  23. Should I use SQL_Variant data type?
  24. How to escape square brackets inside square brackets for field name
  25. Cumulative Total in MS Sql server [duplicate]
  26. SQL query to group by day
  27. Export table data from one SQL Server to another
  28. SQL can I have a “conditionally unique” constraint on a table?
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. SQL, How to Concatenate results?

Leave a Comment