Retrieve multiple nodes as rows from XML column, and shred attributes

My goal is to shred multiple attribute values stored in multiple nodes of an XML column of a table.  Must also return values from the other columns of the same table.  There's a lot of records and a large XML column, therefore the T-SQL must be high performance.

Best way to describe the problem is using an example.

Sample XML:
<Bookbag>
     <Book Id="1" Name="SQL"/>
     <Book Id="2" Name="C#"/>
</Bookbag>
<Bookbag>
     <Book Id="1" Name="Java"/>
     <Book Id="2" Name="SQL"/>
</Bookbag>

Sample Table Output:
TransactionId     XML
----------------     -------------------------------------------------------------------------------------------------
1                        <Bookbag><Book Id="1" Name="SQL" /><Book Id="2" Name="C#" /></Bookbag>
2                        <Bookbag><Book Id="1" Name="Java" /><Book Id="2" Name="SQL" /></Bookbag>

Goal - Result should look like:
TransactionId      ID      Name
-----------------      ---      -----------
1                              1      SQL
1                              2      C#
2                              1      Java
2                              2      SQL

I've included some code that put me on a dead end path, but it might show what I'm trying to do.  Notice the table variable only returns one record, and also notice it cannot return the value of the TransactionId.  I also want to accomplish the goal by not using a table variable so I can use set operations and reduce memory overhead for performance.

Thank you,

Jake

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

/* Create sample table. */
Declare @BookBags Table
	([TransactionId] [int] NOT NULL,
	[BookBag] [xml] NOT NULL)
 
/*  Insert sample values */
Insert Into @BookBags (TransactionId, Bookbag)
	Select 1, '<Bookbag> <Book Id="1" Name="SQL"/> <Book Id="2" Name="C#"/> </Bookbag>'
Insert Into @BookBags (TransactionId, Bookbag)
	Select 2, '<Bookbag> <Book Id="1" Name="Java"/> <Book Id="2" Name="SQL"/> </Bookbag>'
 
/*  Bad Example of how to via XML variable (which is not desired!).
	Problems:
		A: XML variable holds only one table record.  Need both records.
		B: Want to select from table, not XML variable.
		C: Need TransactionId from table.
*/
Declare @BookBagXML Xml
Select @BookBagXML = BookBag From @BookBags
 
Select 
	  [TransactionId] = 'I need this value from the table'
	 ,[Book_Id]	= x.Book.value('@Id[1]', 'int')  
	 ,[Book_Name]	= x.Book.value('@Name[1]', 'varchar(100)')  
From @BookBagXML.nodes('/Bookbag/Book') As x ( Book )