Concatenate row values

• igngua

  SSCrazy

  Points: 2510

  More actions

  December 17, 2010 at 10:28 am

  #229715

  Hi!

  I´ve the table

  USE [labmanager2]

  GO

  /****** Object: Table [dbo].[DESTINATARIO] Script Date: 12/17/2010 14:21:32 ******/

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[DESTINATARIO](

  [DESTID] [smallint] IDENTITY(1,1) NOT NULL,

  [DESTNOMBRE] [varchar](60) COLLATE Modern_Spanish_CI_AS NULL,

  [DESTEMAIL] [varchar](60) COLLATE Modern_Spanish_CI_AS NULL,

  [TMAILID] [smallint] NULL,

  PRIMARY KEY CLUSTERED

  (

  [DESTID] ASC

  )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

  ) ON [PRIMARY]

  GO

  SET ANSI_PADDING OFF

  I need to get all the 'destemail' where tmailid is '11' and the result is concatenated.

  Destnombre destemail tmailid

  Ignacio peralesiperales@matrix.cl 11

  Monica jerezmjerez@matrix.cl 8

  Felipe Ortegafortega@matrix.cl 9

  Edmundo Ruizeruiz@matrix.cl 11

  So i need the uotput to be;

  'iperales@matrix.cl;eruiz@matrix.cl'

  thanks in advance.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  December 17, 2010 at 11:17 am

  #1264180

  select destemail + ';'

  from [dbo].[DESTINATARIO]

  where tmailid = 11

  for xml path('');

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon