Construct date from year and week number in MSSQL

by

Use DATEADD

Rextester Demo

DECLARE @y INT = 2015, 
        @w INT = 37;

SELECT 
  [StartOfWeek] = DATEADD(wk,DATEDIFF(wk,7,CAST(@y AS NVARCHAR(100))) + (@w-1),7);

More Related Contents:

  1. Subquery in select not working in SQL Server
  2. Storing images in SQL Server?
  3. Import Multiple CSV Files to SQL Server from a Folder
  4. Confused about UPDLOCK, HOLDLOCK
  5. Retrieve column definition for stored procedure result set
  6. Using varchar(MAX) vs TEXT on SQL Server
  7. SQL Server – Remove all non-printable ASCII characters
  8. Creating audit triggers in SQL Server
  9. Regular Expressions in SQL Server servers?
  10. Unique constraint on multiple columns
  11. Connecting to MS SQL Server with Windows Authentication using Python?
  12. TSQL Email Validation (without regex)
  13. Dynamic SQL results into temp table in SQL Stored procedure
  14. Diagnosing Deadlocks in SQL Server 2005
  15. How to find the port for MS SQL Server 2008?
  16. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  17. TABLOCK vs TABLOCKX
  18. How to convert number of minutes to hh:mm format in TSQL?
  19. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  20. Dynamically assign filename to excel connection string
  21. Temporarily disable all foreign key constraints
  22. SQL Server Dependencies
  23. SQL Server Passthrough query as basis for a DAO recordset in Access
  24. T-SQL query to show table definition?
  25. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW
  29. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  30. Oracle sequence but then in MS SQL Server

Leave a Comment