Need help on Pivot Query

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  July 19, 2016 at 4:35 am

  #311846

  declare @sample table

  (

  ID int,

  s1 varchar(10),

  s2 varchar(10)

  )

  insert into @sample values (1, 'A' , null )

  insert into @sample values (1, null, 'C' )

  select * from @sample

  i need output like this

  ID S1 S2

  1 A C

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Eirikur Eiriksson

  SSC Guru

  Points: 182911

  More actions

  July 19, 2016 at 5:09 am

  #1890807

  Quick suggestion, add max on the values and group by the ID.

  😎

• sunita2912

  SSC Veteran

  Points: 295

  More actions

  July 21, 2016 at 10:46 am

  #1891388

  There are quite a few good articles on the internet with examples.

  https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

• anupkumarmishra29

  SSC Enthusiast

  Points: 178

  More actions

  August 3, 2016 at 1:55 am

  #1893415

  select id,max(s1) value1 ,max(s2) value2 from @sample group by id