NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Views > dbo.vDiabloFailedRowDetail

Dependencies for View: Util.dbo.vDiabloFailedRowDetail

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.vDiabloFailedRowDetail	View	Util.dbo.DiabloFailedRowDetail	Table	1	[Util].[dbo].[DiabloFailedRowDetail]

View: Util.dbo.vDiabloFailedRowDetail

CREATE VIEW vDiabloFailedRowDetail
AS
SELECT  [Id],
        [Processed],
        [recipients],
        (SELECT 1 AS tag, NULL AS parent, '

' + [subject] + '

' AS [Q!1!Q!CDATA]
        FOR
         XML EXPLICIT,
             TYPE) AS [subject],
        (SELECT 1 AS tag, NULL AS parent, '

' + [body] + ISNULL ([Info], '') + '

' AS [Q!1!Q!CDATA]
        FOR
         XML EXPLICIT,
             TYPE) AS [body],
        (SELECT 1 AS tag, NULL AS parent, '

' + [SQL] + '

' AS [Q!1!Q!CDATA]
        FOR
         XML EXPLICIT,
             TYPE) AS [SQL],
        [ProcessStartTime],
        [ProcessEndTime]
FROM    [dbo].[DiabloFailedRowDetail](NOLOCK)

Description for View: Util.dbo.vDiabloFailedRowDetail

Todo