Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    5

    Unanswered: Turning one record into multiple records...

    Whoops...

    I have the following multi-column table...

    A 01 02 03

    and I want to SELECT in such a way that the result set looks like this...

    A 01
    A 02
    A 03

    Seems simple - but I'm missing it... Thanks in advance!
    Last edited by EOS3; 02-14-03 at 16:49.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if the columns are called PK, COL1, COL2, ...

    select PK, COL1
    union all
    select PK, COL2
    union all
    ...


    rudy

  3. #3
    Join Date
    Feb 2003
    Posts
    5

    Thanks so much...

    for the help! Works like a champ!

Posting Permissions

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