Here's the fixed code:

SET @tableHTML = N'<table border="1">' +

N'<tr><th>Key</th><th>TO Type</th><th>Employee</th><th>TO Hour(s)</th>' +

N'<th>Create Date</th><th>Create By</th><th>Comment</th><th>Earned</th></tr>' +

CAST(( SELECT SnapshotBefore.query(

'for $b in

/DocumentElement/Accrual

return...

Below is snip of my xml. As you can see, nothing fancy and all the other nodes output data as expected.

<DocumentElement>

<Accrual>

<pkID>0</pkID>

...