Dump Source Format Mappings

This page is under construction.

SELECT fmap.c.value('@src', 'nvarchar(max)') AS src_field
	,fmap.c.value('@dst', 'nvarchar(max)') AS dst_field
	,vmap.c.value('@src', 'nvarchar(max)') AS src_val
	,vmap.c.value('@dst', 'nvarchar(max)') AS dst_val
	,lp.[value] AS [Prompt Value]
FROM [source.format] sf
CROSS APPLY sf.[remap].nodes('/transform/map') AS fmap(c)
CROSS APPLY sf.[remap].nodes('/transform/map/val') AS vmap(c)
LEFT JOIN [lookup.prompt] lp
	ON lp.[id] = try_cast(vmap.c.value('@dst', 'nvarchar(max)') AS UNIQUEIDENTIFIER)
WHERE sf.[id] = '<guid>'