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

Re: Query doubt

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx05.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Query doubt
Date	Thu, 09 May 2013 10:31:59 +0200
Organization	Erland Sommarskog
Lines	31
Message-ID	<XnsA1BB6B26748D0Yazorman@127.0.0.1> (permalink)
References	<2cf8c85b-2191-411a-ad1f-c252a17d3b73@m4g2000vbr.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="78e2ae7e6764121e217a035f19bdb315"; logging-data="17874"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1++OA7neuFZVCJUc9WD9aSz"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:m5C/2HU7sUAIeLfncV3uTdhafCQ=
Xref	csiph.com comp.databases.ms-sqlserver:1472

Show key headers only | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | 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