Replace Function In SQL 2005
Join the DZone community and get the full member experience.
Join For Free// 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
sql
Opinions expressed by DZone contributors are their own.
Comments