Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Transpose or Pivot data
 
From:   Dsilva, Simson

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023