Are you looking for something like the following?

DECLARE @x XML

SET @x =

'

'

-- Total count of Nodes

DECLARE @max-2 INT, @i INT

SELECT

@max-2 = @x.query('

{ count(/Employees/Employee) }

').value('e[1]','int')

-- Set counter variable to 1

SET @i = 1

-- variable to store employee name

DECLARE @EmpName VARCHAR(10)

-- loop starts

WHILE @i <= @max-2 BEGIN

-- select "Name" to the variable

SELECT

@EmpName = x.value('Name[1]', 'VARCHAR(20)')

FROM

@x.nodes('/Employees/Employee[position()=sql:variable("@i")]')

e(x)

-- print the name

PRINT @EmpName

-- increment counter

SET @i = @i + 1

END