Transpose Data from Duplicated records?

• marcus.mcdowell

  Old Hand

  Points: 370

  More actions

  November 18, 2009 at 3:27 am

  #140040

  I have a view setup from an SMS database which lists servers. Within the results there is a field for IP Address. Obviously a server can have more than one IP address, so there will be more than one record for each server in the results set each showing the different IPs. The question is, how do I get from this:

  Server NameIP Address

  LBR123410.1.123.123

  LBR1234100.10.98.76

  to this:

  Server NameIP Address 1IP Address 2

  LBR123410.1.123.123100.10.98.76

  I know that it is possible to transpose using SQL if you know how many rows of data are to be transposed, but a server has an unknown number of IP addresses. How could this be achieved? It is in SQL2005.

  Many thanks.

• Puja Shah

  SSCommitted

  Points: 1724

  More actions

  November 18, 2009 at 5:19 am

  #1080801

  Hi,

  You will get help from this link:

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101541

  Regards,

  Puja