Strange issue with SQL query within workflows

When I run the following query in SQL it returns a single value that is an XML representation of the client list.

SELECT 
    [Client].[Id]           'ClientId',
    [Client].[name]         'ClientName',
    [Client].[net_hostname] 'ClientHostName'
FROM            
    [CommServ].[dbo].[APP_Client] AS [Client]    
WHERE
	[Client].[status] = 2
FOR XML RAW, ROOT('ClientInfo');

The goal is to use xpath to do queries against the list rather then doing constant queries.

The problem is that when I run it in a workflow it looks like it paginates the results so it returns multiple rows.

Is there another way to do this?