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: SQL help
Date: Fri, 30 Sep 2011 15:01:32 -0400
Organization: Aioe.org NNTP Server
Lines: 27
Message-ID: <j653m9$84v$1@speranza.aioe.org>
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:691

  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 
?

Thanks