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

Re: SQL help

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	"Phil Hunt" <aaa@aaa.com>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SQL help
Date	Fri, 30 Sep 2011 15:43:34 -0400
Organization	Aioe.org NNTP Server
Lines	48
Message-ID	<j65653$edc$1@speranza.aioe.org> (permalink)
References	<j653m9$84v$1@speranza.aioe.org> <j655ug$uv3$1@dont-email.me>
NNTP-Posting-Host	1F4WqZgmZBperfMg6Tnoqw.user.speranza.aioe.org
X-Complaints-To	abuse@aioe.org
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6109
X-RFC2646	Format=Flowed; Original
X-Notice	Filtered by postfilter v. 0.8.2
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-Priority	3
X-MSMail-Priority	Normal
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:696

Cross-posted to 2 groups.

Show key headers only | View raw

Thanks guys.
It is not the table. I am showing the tuples after a whole bunch of joins.
I should be able to work this into my scheme.


"Lennart Jonsson" <erik.lennart.jonsson@gmail.com> wrote in message 
news:j655ug$uv3$1@dont-email.me...
> On 2011-09-30 21:01, Phil Hunt wrote:
>>   Table2 ID Status
>>       789 4
>>       789 4
>>       1374
>>
>>       1374
>>
>>       1374
>>
>>       1940 15
>>       1940 15
>>       1940 15
>>
>>
>> I want to Select the above to output the followng
>>
>> 789    0
>> 1374   0
>> 1940    1 (because it has Status of 15)
>>
>>
>> I have been staring at this so long, my head and eye hurts. Can someone 
>> help
>> ?
>>
>
> I assume there is a good reason for the design of this table. Something
> like:
>
> select id, max(case when status = 15 then 1 else 0 end)
> from t2
> group by id
>
> will do.
>
>
> /Lennart
>

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

Thread

SQL help "Phil Hunt" <aaa@aaa.com> - 2011-09-30 15:01 -0400
  Re: SQL help Hugo Kornelis <hugo@perFact.REMOVETHIS.info.INVALID> - 2011-09-30 21:34 +0200
  Re: SQL help Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-09-30 21:39 +0200
    Re: SQL help "Phil Hunt" <aaa@aaa.com> - 2011-09-30 15:43 -0400

csiph-web