UFN_AGINGBUCKET_FROMPERIODLISTXML

Returns a table representation of the xml parameter

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PERIODLISTXML	xml	IN

Definition

Copy



        create function dbo.UFN_AGINGBUCKET_FROMPERIODLISTXML(@PERIODLISTXML XML)
        returns TABLE as
        return (
        select
            T.c.value('(ID)[1]', 'uniqueidentifier') as 'ID',
            T.c.value('(PERIODNUMBER)[1]', 'int') as 'PERIODNUMBER',
            T.c.value('(PERIODSTART)[1]', 'varchar(20)') as 'PERIODSTART',
            T.c.value('(PERIODEND)[1]', 'varchar(20)') as 'PERIODEND',
            T.c.value('(PERIODDESCRIPTION)[1]', 'varchar(20)') as 'PERIODDESCRIPTION' 
        from @PERIODLISTXML.nodes('/AGINGBUCKETAPXML/ITEM') T(c)
  )