SQL Server parse XML

The SQL below builds a test XML variable
WHat I need to do in SQL Server is loop through the nodes...
For EACH demovalue... in @XMLVar

Declare @IndividualID INT
Declare @CustomID INT
Declare @Commentsl VARCHAR (100)
SET @IndividualID = @XMLVar.....demovalues/demovalue/ind..value
Set @Comments  = @XMLVar.....demovalues/demovalue/val..value
Set @CustomID = (Select id from myDemoTable where DemoText = )
(I know I butchered that...)

And then,,,
 INSERT INTO indDemoTable (IndividualID, CustomID, Comments)
Select @IndividualID, CustomID, @Comments

DECLARE @XMLVar XML
SET @Var = '<demovalues><demovalue><ind>123456</ind><id>holder</id><val>TEST TEXT 33</val></demovalue><demovalue><ind>123457</ind><id>holder</id><val>TEST TEXT 34</val></demovalue></demovalues>'
SELECT @Var

Select allOpen in new window