Home Forums SQL Server 2008 SQL Server 2008 - General How to display current week as 0 for each year RE: How to display current week as 0 for each year

  • August 1, 2012 at 7:30 am

    #1520251

    84gopi (8/1/2012)

    Hi,

    PFA doc of my report requirement.

    Thanks

    Gopi

    good, you are one third of the way there!

    1. CREATE TABLE stuff: missing...

    2. INSERT INTO stuff...missing.

    3. xpected Output...attached.

    a word doc or screenshots is not a substitute for the CREATE TABLE...INSERT INTO.

    it does help as far as the expected output, however.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!