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?
