Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    111

    Unanswered: temp table transformation...

    i have a temporary table from a select statement as follows:

    Id Type Amount
    11 1001 6072
    11 1002 1476.02
    11 1003 6738.92
    11 1004 950

    i want to select from it such that i get the following result set, can anyone please help? TIA


    Id T1 A1 T2 A2 T3 A3 T4 A4
    11 1001 6072 1002 1476.02 1003 6738.92 1004 950

  2. #2
    Join Date
    Aug 2008
    Posts
    1
    try use PIVOT operator

  3. #3
    Join Date
    Jul 2006
    Posts
    111

    have to enumerate all possible rows when using pivot?

    or is there another way akin to using BETWEEN instead of enumerating rows within IN

    thanks again

Posting Permissions

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