Display monthly data into no of weeks

• mahesh15dec1986

  SSC Veteran

  Points: 247

  More actions

  February 24, 2012 at 4:18 am

  #251229

  Hi Team

  i have a data of year 2012 and table structure is (SN ,Name ,DATE,Error) and i need count of Error according to weeks as below

  1 Jan 2012 to 5 Jan 2012- Week 1

  6 Jan 2012 to 12 Jan 2012 week 2

  13 Jan 2012 to 19 Jan 2012 week 3

  20 Jan 2012 to 26 Jan 2012 week 4

  27 Jan 2012 to 31 Jan 2012 week 6

  1 Feb 2012 to 2 Feb 2012 week 7

  3 Feb 2012 to 9 Feb 2012 week 8

  10 Feb 2012 to 16 Feb 2012 week 9

  17 Feb 2012 to 23 Feb 2012 week 10

  24 Feb 2012 to 29 Feb 2012 week 11--------------------------------------

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  February 24, 2012 at 4:20 am

  #1451299

  Duplicate post.

  Please don't post your question twice, it fragments replies and makes it much more difficult for the unpaid volunteers of this site to help.

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---