Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Select Into Query

DZone's Guide to

Select Into Query

·
Free Resource

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:

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

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

X

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

{{ parent.tldr }}

{{ parent.urlSource.name }}