top of page
ค้นหา

Technical : Query COACH HR data with correct formatting

Use the appropriate query statement to get the correct data formatting.

SELECT

STUFF(

( SELECT ',' + 'USA <USA@foo.com>'

FOR XML PATH('')

), 1, 1, '') AS [STUFF]

,

STUFF(

( SELECT ',' + 'USA <USA@foo.com>'

FOR XML PATH(''), TYPE

).value('.[1]', 'NVARCHAR(MAX)'), 1, 1, '') AS [FORMATSTUFF]

,

SUBSTRING(

( SELECT ',' + 'USA <USA@foo.com>'

FOR XML PATH('')

), 2, 9999) AS [SUBSTRING]

,

SUBSTRING(

( SELECT ',' + 'USA <USA@foo.com>'

FOR XML PATH(''), TYPE

).value('.[1]', 'NVARCHAR(MAX)'), 2, 9999) AS [FORMATSUBSTRING]

ดู 16 ครั้ง0 ความคิดเห็น

โพสต์ล่าสุด

ดูทั้งหมด

Comentários


bottom of page