Query

• RaviShankar1234

  SSCommitted

  Points: 1647

  More actions

  March 28, 2011 at 10:54 am

  #99285

  Hi all,

  I need some help in writing this query.

  table stucture is :

  col1 col2

  10.69.56.109 A

  10.69.56.109 B

  10.69.56.109 c

  10.69.56.109 D

  10.69.56.109 E

  10.69.56.109 F

  10.69.56.109 G

  If the count of Col1>5 then

  col1 col2

  10.69.56.109 a,b,c,e,f,g

  can anyone help me with this please.

  thx,

  Ravi

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  April 1, 2011 at 4:21 pm

  #1306714

  Hi,

  This is what you are looking for

  declare @Temp table(h varchar(50) ,J varchar(5))

  insert @Temp

  Select '10.69.56.109', 'A'

  UNION ALL Select '10.69.56.109', 'B'

  UNION ALL Select '10.69.56.109', 'C'

  UNION ALL Select '10.69.56.109', 'D'

  UNION ALL Select '10.69.56.109', 'E'

  UNION ALL Select '10.69.56.109', 'F'

  UNION ALL Select '10.69.56.109', 'G'

  -- Select * from @Temp

  SELECT DISTINCT h,SUBSTRING((SELECT ','+j AS [text()] FROM @Temp WHERE h = T.h ORDER BY j FOR XML PATH( '' ) ), 2,200) AS J

  FROM @Temp AS T;

  Thanks
  Parthi