I'm running this query against the comserv database and I'm getting the correct results in a XML format.However I'm getting the same information 96 times in the same row and I only want the information once. Example query is below.
from [dbo].[CommCellVMBackupInfo] vm INNER JOIN APP_ClientGroupAssoc a ON vm.vmclientid = a.clientId
inner join APP_Client c on vm.vmclientid = c.id
WHERE a.clientGroupId in (Select id From APP_ClientGroup Where name = 'AutomationGroup')
for xml path;
This is the correct information that I'm receiving but It is repeated 96 times and I only want the information once as displayed below