jgdoncel
12/17/2013 - 8:24 AM

Transact SQL: Equivalente a GROUP_CONCAT de MySQL

Transact SQL: Equivalente a GROUP_CONCAT de MySQL

SELECT
  STUFF(
    (
      SELECT 
        ',' + RTRIM(LTRIM(TELEFONO))
			FROM CLIENTE
			WHERE CLIENTE = '10655'
			ORDER BY TELEFONO FOR xml path('')
		)
    , 1, 1, '')