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:41 am

    #1520270

    84gopi (8/1/2012)

    Hi,

    I have merchandise week table in my package which contains week values wk1,wk2,wk3.....upto wk53 per year.

    So using this i need to display current week as 0, for any season like spring2009 or fall2009 etc.......

    Let me know if you need more details.....

    Thanks

    Gopi

    athe details i need are the CREATE TABLE YourMerchandiseTable...

    and some INSERT INTO example rows.

    please don't copy and paste the same info over and over again...i know there is a language barrier problem, but please try.

    something like this?

    CREATE TABLE [dbo].[MYMERCHANDISE] (

    [ID] INT NULL,

    [SALEDATE] DATETIME NULL,

    [DESCRIP] VARCHAR(30) NULL)

    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!