Parse XML in T-SQL

gistfile1.sql

DECLARE @XML XML
SET @XML ='<Facility>	
	<Resources>
		<Resource Type="Printer">
			<Item Id="3" Value="Bubbleshots Deskjet Pro" />
			<Item Id="253" Value="Topware LaserPrinter 5000" />
			<Item Id="7" Value="Jabberbox ClassyImage" />
			<Item Id="89" Value="Photoopia Megastar Over9000" />
		</Resource>
		<Resource Type="Phone">
			<Item Id="24" Value="Bananaphone L37" />
		</Resource>
	</Resources>	
</Facility>'

SELECT
    Id    = item.value('(@Id)', 'INT'),
    Value = item.value('(@Value)', 'NVARCHAR(128)')
FROM @XML.nodes('//Facility/Resources/Resource/Item') AS Facility(item)
WHERE item.value('(../@Type)', 'NVARCHAR(128)') = 'Printer'