Over a million developers have joined DZone.

Select Into Query

·

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('')), ' ', ' '), '
', ' ')
INTO NOTITIE
FROM         dbo.CL_PROBLEM_HISTORY c
Topics:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}