Need help on results output

  • Hi guys.

    I need help  with query results output.

    I have the following table:

    create table MyTable(HH int,F int,T int,Val int)

    insert into MyTable (HH,F,T,Val)

    values(2,6,7,11),

    (2,6,10,1),

    (3,7,6,12),

    (3,6,7,17),

    (4,6,7,15)

    I need to show those F/T values on the same HH. Something like this

    HH    F     T     VAL     F     T    VAL    F    T    VAL

    2        6      7       11       6     10      1

    3       6      7       17       7      6       12     6     10     1

    4       6      7       15

    Thank You in advance

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply