b18d8b55   
   From: esquel@sommarskog.se   
      
   contracer (contracer11@gmail.com) writes:   
   > Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs   
   > WITH (NOLOCK)   
   > INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID   
   > INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID   
   > where ccs.ErrorMessage LIKE '%atingiu%'   
   > order by 2 asc   
   >   
   > I get:   
   >   
   > SERVER1      FS /apl/orawpsp atingiu 90% de utilizacao -> 533 MB   
   > disponiveis -   
   >                  FS /bd1/orawppdata/sys atingiu 90% de utilizacao ->   
   > 199 MB disponiveis -   
   >   
   >   
   > How could I change this query to get output below:   
   >   
   > SERVER1      FS /apl/orawpsp atingiu 90% de utilizacao -> 533 MB   
   > disponiveis -   
   > SERVER1  FS /bd1/orawppdata/sys atingiu 90% de utilizacao -> 199 MB   
   > disponiveis -   
      
   So does this query only return a single row, and ccs.errormessage has   
   text with a line feed in it? That would be the only explanation for   
   the server name only being listed once. But I am not familiar with   
   your tables, so I might be missing something.   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)