Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Help with a view and a possible 52 week table

Results 1 to 2 of 2
Share This Thread →
  1. #1
    Harryv is offline Registered User
    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
    gk53's Avatar
    gk53 is offline Contributing User
    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,535
    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

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates