Over a million developers have joined DZone.

Replace Function In SQL 2005

·
// description of your code here


SELECT 
     DISTINCT CALL_NUMBER, 

        Actie = 
		Replace (
		REPLACE( 
        ( 
            SELECT 
                ACTIONS_DESC AS [data()] 
            FROM 
                 dbo.CL_PROBLEM_HISTORY clh 
            WHERE 
                clh.CALL_NUMBER = c.CALL_NUMBER 
            ORDER BY 
                CALL_NUMBER, HISTORY_ORDER
            FOR XML PATH ('') 
        ), ' ', ' ') 
		
		, '
', ' ')
FROM 
    dbo.CL_PROBLEM_HISTORY c
ORDER BY 
    CALL_NUMBER
Topics:

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}