Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    1

    Red face Unanswered: Stored Procedure

    Hi,

    I have a problem that I have the source table (CP) as

    CD_1 CD_2 CD_3
    a x 1
    b y 2

    and my target table is like below :

    a b
    x 1
    y 2

    Can any one please suggest me stored procedure for this

    Means a and b became the column headings for x y and 1 2.

    can any one please suggest me .

    Thanks in advance.

    Thanks
    Arjun

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    SELECT CD_2 a, CD_3 B
    FROM CP
    ORDER BY CD2,CD3;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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