UFN_VSECONSTITUENCY_FROMITEMLISTXML

            create function [dbo].[UFN_VSECONSTITUENCY_FROMITEMLISTXML](@ITEMLISTXML xml) 
            returns table as
            return (
            select
                T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
                T.c.value('(VSECONSTITUENCY)[1]','nvarchar(31)') AS 'VSECONSTITUENCY'
            FROM  @ITEMLISTXML.nodes('/VSECONSTITUENCIES/ITEM') T(c)
            )