Groups > comp.databases.ms-sqlserver > #1471

Query doubt

Newsgroups	comp.databases.ms-sqlserver
Date	2013-05-08 18:33 -0700
Message-ID	<2cf8c85b-2191-411a-ad1f-c252a17d3b73@m4g2000vbr.googlegroups.com> (permalink)
Subject	Query doubt
From	contracer <contracer11@gmail.com>

Show all headers | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Query doubt contracer <contracer11@gmail.com> - 2013-05-08 18:33 -0700
  Re: Query doubt Erland Sommarskog <esquel@sommarskog.se> - 2013-05-09 10:31 +0200
  Re: Query doubt rja.carnegie@gmail.com - 2013-05-09 13:56 -0700

csiph-web