Post reply

simple dynomic Transpose 2 column as 2 rows

  • August 26, 2016 at 2:02 am

    #329683

    Hi friends ,

    i would like to transpose powerunit_natlang and transmission_natlang columns. please some one help me.

    create table #urgent_2_11 (id int,cc_key varchar(50),technical_item_name_natlang varchar(50),modeltrim_name varchar(50),powerunit_natlang varchar(50),

    transmission_natlang varchar(50),category_name_natlang varchar(50))

    insert into #urgent_2_11 values(12017,'28c6483296abe739646b0b91b1d17fb4','Cilindrada','like','1,0 MPI 75 CV','Auto 5 vel.','Motorización y transmisión')

    insert into #urgent_2_11 values(12022,'28c6483296abe739646b0b91b1d17fb4','Cilindrada','Like','1,0 MPI 75 CV','Manual 5 vel.','Motorización y transmisión')

    insert into #urgent_2_11 values(12013,'28c6483296abe739646b0b91b1d17fb4','Largo','Like','1,0 MPI 75 CV','Manual 5 vel.','Dimensiones exteriores')

    insert into #urgent_2_11 values(12014,'28c6483296abe739646b0b91b1d17fb4','Ancho','Like','1,0 MPI 75 CV','Manual 5 vel.','Dimensiones exteriores')

    insert into #urgent_2_11 values(12015,'28c6483296abe739646b0b91b1d17fb4','Alto','Like','1,0 MPI 75 CV','Manual 5 vel.','Dimensiones exteriores')

    insert into #urgent_2_11 values(12016,'28c6483296abe739646b0b91b1d17fb4','Distancia entre ejes','Like','1,0 MPI 75 CV','Manual 5 vel.','Dimensiones exteriores')

    select * from #urgent_2_11

    expected_output :

    please find the below attachment :

  • August 26, 2016 at 2:07 am

    #1897722

    Please don't post the same question in multiple places. No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1812729-3077-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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