UFN_REPORT_TAXCLAIMBREAKDOWN_GETSITESSELECTEDXML

Returns XML containing the list of sites selected.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@SITESSELECTED	nvarchar(max)	IN

Definition

Copy



            create function dbo.UFN_REPORT_TAXCLAIMBREAKDOWN_GETSITESSELECTEDXML
            (
                @SITESSELECTED nvarchar(max)
            )
            returns xml
            as
            begin
                declare @SITESSELECTEDXML xml
                if coalesce(@SITESSELECTED, '') <> ''
                begin
                    declare @SITESSELECTEDTBL table (SITEID uniqueidentifier)

                    while charindex(',', @SITESSELECTED) > 0
                    begin
                        insert @SITESSELECTEDTBL (SITEID)
                        select ltrim(rtrim(substring(@SITESSELECTED, 1, charindex(',', @SITESSELECTED) - 1)))

                        select @SITESSELECTED = ltrim(rtrim(substring(@SITESSELECTED, charindex(',', @SITESSELECTED) + 1, len(@SITESSELECTED))))
                    end

                    insert into @SITESSELECTEDTBL (SITEID)
                    select rtrim(ltrim(@SITESSELECTED))

                    set @SITESSELECTEDXML = (    select SITEID from @SITESSELECTEDTBL
                                                for xml raw('ITEM'),type,elements,root('SITESSELECTED'),binary base64)
                end

                return @SITESSELECTEDXML
            end