CREATE TABLE #output
(line varchar(255))

INSERT INTO #Output values ('<?xml version="1.0"?>')
INSERT INTO #Output values ('<Objects>')
INSERT INTO #Output values ('  <Object>')
INSERT INTO #Output values ('    <Property Name="Folder">\\SERVER1\Clients\APHE\Accounts</Pr')
INSERT INTO #Output values ('operty>')
INSERT INTO #Output values ('    <Property Name="Access">Modify, Synchronize</Property>')
INSERT INTO #Output values ('    <Property Name="User">Domain1\User3</Property>')
INSERT INTO #Output values ('  </Object>')
INSERT INTO #Output values ('  <Object>')
INSERT INTO #Output values ('    <Property Name="Folder">\\SERVER1\Clients\APHE\Location</Property>')
INSERT INTO #Output values ('    <Property Name="Access">Modify, Synchronize</Property>')
INSERT INTO #Output values ('    <Property Name="User">Domain1\User3</Property>')
INSERT INTO #Output values ('  </Object>')
INSERT INTO #Output values ('  <Object>')
INSERT INTO #Output values ('    <Property Name="Folder">\\SERVER1\Clients\BPE\Accounts</Pr')
INSERT INTO #Output values ('operty>')
INSERT INTO #Output values ('    <Property Name="Access">ReadAndExecute, Synchronize</Property>')
INSERT INTO #Output values ('    <Property Name="User">Domain1\User2</Property>')
INSERT INTO #Output values ('  </Object>')
INSERT INTO #Output values ('  <Object>')
INSERT INTO #Output values ('    <Property Name="Folder">\\SERVER1\Clients\BPE\Location</Pr')
INSERT INTO #Output values ('operty>')
INSERT INTO #Output values ('    <Property Name="Access">Modify, Synchronize</Property>')
INSERT INTO #Output values ('    <Property Name="User">Domain1\User1</Property>')
INSERT INTO #Output values ('  </Object>')
INSERT INTO #Output values ('  <Object>')
INSERT INTO #Output values ('    <Property Name="Folder">\\SERVER1\Clients\BPE\Comments</Pr')
INSERT INTO #Output values ('operty>')
INSERT INTO #Output values ('    <Property Name="Access">ReadAndExecute, Synchronize</Property>')
INSERT INTO #Output values ('    <Property Name="User">Domain1\User2</Propert')
INSERT INTO #Output values ('y>')
INSERT INTO #Output values ('  </Object>')
INSERT INTO #Output values ('  <Object>')
INSERT INTO #Output values ('    <Property Name="Folder">\\SERVER1\Clients\PRD\Accounts</Pr')
INSERT INTO #Output values ('operty>')
INSERT INTO #Output values ('    <Property Name="Access">ReadAndExecute, Synchronize</Property>')
INSERT INTO #Output values ('    <Property Name="User">Domain1\User3</Propert')
INSERT INTO #Output values ('y>')
INSERT INTO #Output values ('  </Object>')
INSERT INTO #Output values ('</Objects>')


DELETE #output WHERE line IS NULL


DECLARE @doc varchar(max)
SET @doc = ''
DECLARE @line varchar(255)
DECLARE xml_cursor CURSOR
FOR SELECT line FROM #output
OPEN xml_cursor
FETCH NEXT FROM xml_cursor INTO @line
WHILE @@FETCH_STATUS = 0
BEGIN
SET @doc = @doc + @line
FETCH NEXT FROM xml_cursor INTO @line
END
CLOSE xml_cursor
DEALLOCATE xml_cursor

SELECT
item.ref.value('(Property/text())[1]', 'nvarchar(200)') AS Folder
,item.ref.value('(Property/text())[2]', 'nvarchar(500)') AS Access
,item.ref.value('(Property/text())[3]', 'nvarchar(200)') AS UserGroup
FROM (SELECT CAST(@doc AS XML) AS feedXml) feeds(feedXml)
CROSS APPLY feedXml.nodes('/Objects/Object') AS item(ref)

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#output') IS NOT NULL 
    DROP TABLE #output;
	
CREATE TABLE #output (line VARCHAR(255))

INSERT  INTO #Output
VALUES  ('<?xml version="1.0"?>'),
        ('<Objects>'),
        ('  <Object>'),
        ('    <Property Name="Folder">\\SERVER1\Clients\APHE\Accounts</Pr'),
        ('operty>'),
        ('    <Property Name="Access">Modify, Synchronize</Property>'),
        ('    <Property Name="User">Domain1\User3</Property>'),
        ('  </Object>'),
        ('  <Object>'),
        ('    <Property Name="Folder">\\SERVER1\Clients\APHE\Location</Property>'),
        ('    <Property Name="Access">Modify, Synchronize</Property>'),
        ('    <Property Name="User">Domain1\User3</Property>'),
        ('  </Object>'),
        ('  <Object>'),
        ('    <Property Name="Folder">\\SERVER1\Clients\BPE\Accounts</Pr'),
        ('operty>'),
        ('    <Property Name="Access">ReadAndExecute, Synchronize</Property>'),
        ('    <Property Name="User">Domain1\User2</Property>'),
        ('  </Object>'),
        ('  <Object>'),
        ('    <Property Name="Folder">\\SERVER1\Clients\BPE\Location</Pr'),
        ('operty>'),
        ('    <Property Name="Access">Modify, Synchronize</Property>'),
        ('    <Property Name="User">Domain1\User1</Property>'),
        ('  </Object>'),
        ('  <Object>'),
        ('    <Property Name="Folder">\\SERVER1\Clients\BPE\Comments</Pr'),
        ('operty>'),
        ('    <Property Name="Access">ReadAndExecute, Synchronize</Property>'),
        ('    <Property Name="User">Domain1\User2</Propert'),
        ('y>'),
        ('  </Object>'),
        ('  <Object>'),
        ('    <Property Name="Folder">\\SERVER1\Clients\PRD\Accounts</Pr'),
        ('operty>'),
        ('    <Property Name="Access">ReadAndExecute, Synchronize</Property>'),
        ('    <Property Name="User">Domain1\User3</Propert'),
        ('y>'),
        ('  </Object>'),
        ('</Objects>');

SELECT  item.ref.value('(Property/text())[1]', 'nvarchar(200)') AS Folder,
        item.ref.value('(Property/text())[2]', 'nvarchar(500)') AS Access,
        item.ref.value('(Property/text())[3]', 'nvarchar(200)') AS UserGroup
FROM    (SELECT CAST((SELECT    '' + line
                      FROM      #output
         FOR    XML PATH(''),
                    TYPE).value('.[1]', 'varchar(max)') AS XML) AS FormattedXML)
        AS Sub
        CROSS APPLY FormattedXML.nodes('/Objects/Object') AS item (ref);

INSERT INTO #xmlData
SELECT CAST((SELECT    '' + line
                      FROM      #output
         FOR    XML PATH(''),
                    TYPE).value('.[1]', 'varchar(max)') AS XML) AS FormattedXML 

SELECT  item.ref.value('(Property/text())[1]', 'nvarchar(200)') AS Folder,
        item.ref.value('(Property/text())[2]', 'nvarchar(500)') AS Access,
        item.ref.value('(Property/text())[3]', 'nvarchar(200)') AS UserGroup
FROM  #xmlData
        AS Sub
        CROSS APPLY XmlData.nodes('/Objects/Object') AS item (ref);