DECLARE @idoc int
DECLARE @Cond nvarchar(max)
SET @Cond =	(
			select	XML_COLUMN
			from	MyTable
			)
--
EXEC sp_xml_preparedocument @idoc OUTPUT, @Cond

DECLARE
	@MatrixCondition TABLE(							
						IDCounter		char(2),
						ID			char(2),
						OrderNumber	char(2),	
						agrPerson		char(20)										
						)
INSERT INTO @MatrixCondition	(
						IDCounter,
						ID,
						OrderNumber,
						agrPerson
						)
SELECT	*
FROM OPENXML (@idoc, '/Rows/Row', 2) WITH
		(
		IDCounter		char(2)			'../@IDCounter',
		ID				char(2)			'@ID',
		OrderNumber		char(2)			'@OrderNumber',
		agrPerson		char(20)		'Cell[@ColumnName = "agrPerson"]/@Value'
		)

-- Очистка
EXEC sp_xml_removedocument @idoc

select	*
from	@MatrixCondition