Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: "Phil Hunt" 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: References: 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 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" 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 >