b18d8b55   
   From: contracer11@gmail.com   
      
   Hi,   
   Please help me solve my doubt.   
   When I execute this query:   
      
   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 -   
      
   Thanks.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)