Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Exclamation Unanswered: Urgent-Challenge: Make tbl_SProc From Vertical to Horizontal

    Hi,

    What I need is the following, a StoredProc that make a Vertical (normal table) into a Horizontal Table :
    So From:
    CustNo__Item

    __1______1
    __1______3
    __1______4
    __2______2
    __2______3
    __2______7

    To:
    CustNo___1__2___3___4___7

    _1_______X______X___X
    _2__________X___X_______X

    Anny help would be verry appriciated
    Last edited by Marvels; 07-07-04 at 10:58. Reason: URGENT

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You might want to look at:

    Rob's Cross tab article
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •