UFN_RELATIONSHIPS_FROMITEMLISTXML

Returns a table of all specified relationships from an xml parameter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONSHIPS	xml	IN

Definition

Copy



CREATE function dbo.UFN_RELATIONSHIPS_FROMITEMLISTXML
(
    @RELATIONSHIPS xml
)
returns table as return(
        select
            T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
            T.c.value('(RELATIONSHIPCONSTITUENTID)[1]','uniqueidentifier') AS 'RELATIONSHIPCONSTITUENTID',
            T.c.value('(RELATIONSHIPTYPECODEID)[1]','uniqueidentifier') AS 'RELATIONSHIPTYPECODEID',
            T.c.value('(RECIPROCALCONSTITUENTID)[1]','uniqueidentifier') AS 'RECIPROCALCONSTITUENTID',
            T.c.value('(RECIPROCALTYPECODEID)[1]','uniqueidentifier') AS 'RECIPROCALTYPECODEID',
            T.c.value('(STARTDATE)[1]','datetime') AS 'STARTDATE',
            T.c.value('(ISSPOUSE)[1]','bit') AS 'ISSPOUSE'
        from
            @RELATIONSHIPS.nodes('/RELATIONSHIPS/ITEM') T(c)
    )