Help with query

• sqldba_VA

  SSCommitted

  Points: 1937

  More actions

  July 2, 2010 at 8:52 am

  #222793

  create table DNS (id int, dns varchar(50), orderid int)

  GO

  insert into DNS values (5001, 'dev.net', 1);

  insert into DNS values (5001, 'QA.net', 2);

  insert into DNS values (5001, 'Test.net', 3);

  select * from DNS gives me data looks like:

  iddnsorderid

  5001dev.net1

  5001QA.net2

  5001Test.net3

  I want to have data which looks like:

  idorderid1orderid2orderid3

  5001dev.netQA.comTest.net

  Can some one out there help me writing this query.

• jjtetzlo

  SSCrazy

  Points: 2511

  More actions

  July 2, 2010 at 9:54 am

  #1188316

  Something like this?

  select

  id

  ,max(case when orderid = 1 then dns else null end) as 'orderid1'

  ,max(case when orderid = 2 then dns else null end) as 'orderid2'

  ,max(case when orderid = 3 then dns else null end) as 'orderid3'

  from

  #DNS

  group by

  id;

  - Jeff

  - Jeff

• sqldba_VA

  SSCommitted

  Points: 1937

  More actions

  July 2, 2010 at 10:24 am

  #1188338

  Thanks Jeff. That's what I needed.