Tuesday, October 26, 2010

Obtener resultado en string separado por comas

DECLARE @var AS NVARCHAR(100)


SELECT @var = COALESCE(convert(nvarchar,@var) + ',' , '') + CONVERT(nvarchar,tabla.id_calendario) FROM
(SELECT distinct(id_calendario) FROM calendario_procesos WHERE anio = 2010 AND tipo_nomina = 'PJ') tabla


SELECT @var

No comments:

Post a Comment