#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2013
    Posts
    1
    Rep Power
    0

    Help with a view and a possible 52 week table


    I have a table which is indexed by WHSE + PRODUCT
    There is another table which I need to look up which is keyed by YEAR (YYYY) +WEEK (01 - 52) + WHSE + PRODUCT.
    The second table is sales by week but there does not have to be a record for every week, onlt the weeks that have sales.
    So the second table may have week 04,05,12, and 50.

    The output should be

    WHSE PRODUCT YEAR WEEK01 WEEK02 WEEK03 WEEK04 .... WEEK52
    Where Week 4,5,12 and 50 would have data all of the other columns would be null.

    I have no Idea how to accomplish this.

    The first table is ICWM the second TABLE is SAWP.

    Thanks for any help you can give.
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,592
    Rep Power
    278
    and what database do you have?
    GK
    __________________________________________________ _____
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree

Similar Threads

  1. Look up table not showing up in Datasheet View on table
    By desireemm1 in forum Microsoft Access Help
    Replies: 1
    Last Post: October 27th, 2009, 12:54 PM
  2. View instead of table
    By jt_work in forum ASP Development
    Replies: 6
    Last Post: March 5th, 2007, 07:21 AM
  3. Table/View Descriptions
    By bklyn3801 in forum Microsoft SQL Server
    Replies: 0
    Last Post: February 9th, 2004, 03:27 PM
  4. asp code to view table name
    By ASPBoston in forum ASP Development
    Replies: 3
    Last Post: December 17th, 2003, 10:31 AM
  5. Replies: 0
    Last Post: December 10th, 2003, 01:15 PM

IMN logo majestic logo threadwatch logo seochat tools logo