yeah, the row count in SSMS is a best guess... it's "4" because if you were to view the XML, it's 4 lines... the results grid is sees it as a single returned entity and so you get "1" ... you should be able to click it, and it opens a new tab with the xml showing... in there you will find your 106 rows. XML is a type in SQL Server... so queries which return XML like that, treat it as a type, making it a single entity and thus, the one row in the results.

-tg