I need a SQL server Func that will calculate a complete date from the week of the year [closed]

by 
declare @input char(4) set @input = 4218

SET DATEFIRST 1
declare @wk int  set @wk = cast(SUBSTRING(@input,1,2) as int)
declare @yr int  set @yr = 2000 + cast(SUBSTRING(@input,3,2) as int)

select dateadd (week, @wk, dateadd (year, @yr-1900, 0)) - 4 -
         datepart(dw, dateadd (week, @wk, dateadd (year, @yr-1900, 0)) - 4) + 1

More Related Contents:

  1. How to split a comma-separated value to columns
  2. Get a list of dates between two dates using a function
  3. What is the use of GO in SQL Server Management Studio & Transact SQL?
  4. Confused about UPDLOCK, HOLDLOCK
  5. Retrieve column definition for stored procedure result set
  6. Using varchar(MAX) vs TEXT on SQL Server
  7. Change Notification with Sql Server 2008
  8. How do you create a yes/no boolean field in SQL server?
  9. Connecting to MS SQL Server with Windows Authentication using Python?
  10. Using COALESCE function to make values separated with commas
  11. TSQL Email Validation (without regex)
  12. How to find the port for MS SQL Server 2008?
  13. How do I create a multiple-table check constraint?
  14. How to convert number of minutes to hh:mm format in TSQL?
  15. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  16. Dynamically assign filename to excel connection string
  17. SQL Server Group by Count of DateTime Per Hour?
  18. Temporarily disable all foreign key constraints
  19. How to import a DBF file in SQL Server
  20. SQL Server Dependencies
  21. T-SQL query to show table definition?
  22. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  23. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  24. Date range overlapping check constraint
  25. Conditional JOIN Statement SQL Server
  26. Is there an “IF EXISTS” test for a linked server?
  27. How do you deal with blank spaces in column names in SQL Server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment