UFN_SPONSORSHIPLOCATIONS_FROMITEMLISTXML

This function is used to form a table from SponsorshipLocations XML

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@LOCATIONLIST	xml	IN

Definition

Copy



      create function dbo.UFN_SPONSORSHIPLOCATIONS_FROMITEMLISTXML(@LOCATIONLIST xml)
      returns table
      as 
      return (
        select
          T.c.value('(SPONSORSHIPLOCATIONID)[1]','uniqueidentifier') as SPONSORSHIPLOCATIONID
          from @LOCATIONLIST.nodes('/FILTERLOCATIONS/ITEM') T(c)
      )