Archives of the TeradataForum

Message Posted: Wed, 05 Aug 2009 @ 12:13:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Fred,

You can make this change & give it a try

     -----------------------------------------------------------------
     Select b.location, b.unit_id,
     sum(b.fault3),sum(b.fault35),sum(b.fault155), sum(b.fault156)

     From
     (
     Select t.location, t.unit_ID,
        (Case When t.fault=3 Then t.FltCnt Else 0 End) as Fault3,
        (Case When t.fault=35 Then t.FltCnt Else 0 End) as Fault35,
        (Case When t.fault=155 Then t.FltCnt Else 0 End) as Fault155,
        (Case When t.fault=156 Then t.FltCnt Else 0 End) as Fault156,
     >From (
     Select location, unit_ID, fault, Count(fault) as FltCnt
     >From database
     Where location = 4443
        And unit_ID = 3124
        And fault=3 OR fault=35 OR fault=155 or fault=156
     Group by location, unit_ID, fault
     ) t
     ) b
     Group by 1, 2;
     -----------------------------------------------------------------

Regards,

Simson

	<Prev	Next>		<<First	<Prev	Next>	Last>>