In Microsoft SQL Server, I have a week number
(from DATEPART(wk, datecol))
But what I would like to do is turn this back into the date span for that week.
SELECT DATEPART(wk, GETDATE())
yields 10. I would like to derive
3/7/2009 from this number.
Is this possible?