Home Forums SQL Server 2005 T-SQL (SS2K5) How to get week of a mont with input parameter date. RE: How to get week of a mont with input parameter date.

  • September 12, 2012 at 1:48 am

    #1536589

    Lynn Pettis (9/11/2012)

    Plus, we only have part of the problem. We should wait for the other shoe to drop and see how this is going to be used in the procedure.

    Also, he did say a parameter was being passed, the single input value, and wanted 7 values returned.

    Also puzzling (to me at least) is the "First week of a actual month" requirement - whereas the sample data supplied was not the first week in September, by my reckoning. Surely it would be the week commencing 2 or 3 September (depending on which day you choose as the start day)?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.