Post reply

converting column data as column name

  • February 22, 2012 at 10:42 pm

    #147018

    Hi , I have a query which return the data like in sql server

    param_value display_value

    64.60.231.79 BROADCAST_2

    0 GATEWAY_2

    64.60.231.72 IP_SUBNET_2

    2 IP_TYPE

    255.255.255.248 NET_MASK_2

    74-78 USABLE_RANGE_2

    64.60.231.73 WAN_IP_2

    Now i want the right side output to make as a column name

    BROADCAST_2 GATEWAY_2 IP_SUBNET_2 IP_TYPE NET_MASK_2 USABLE_RANGE_2 WAN_IP_2

    and the param_values should be below that in a row.

    How can i do that

    PFB for my query

    select a.param_value , p.display_value from service_ext_data a , param_values p

    where view_id in (select top 1 view_id from service_view

    where subscr_no in (select subscr_no from ord_service_order where service_order_id in (

    select service_order_id from ord_service_order where order_id = 405767003

    and wp_process_id = 'Rcnfg-Circuit'

    )) )

    and p.param_id in(10268,10298,10354,10170,10485,10474,10270,10326,10261)

    and p.param_id = a.param_id

    can some one help me please

  • February 23, 2012 at 2:21 am

    #1450701

    Duplicate post. No replies please.

    Discussion already started here.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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