Transform query

• • Reply

  18 years ago

  by kaur_gurpreet

  GURPREET KAUR

  Chandigarh, India, India

  Joined 18 years ago

  SUBSTITUTE FOR TRANSFORM QUERY IN SQL SERVER
  

  
  

  
  i HAVE A TABLE TBL WITH FOLLOWING DATA
  

  
  

  
  customer    region            sale

  
  

  
  A        DELHI            $100.00
  B        CHANDIGARH        $100.00
  C        DELHI            $200.00
  D        DELHI            $300.00
  E        CHANDIGARH        $200.00

  
  

  
  

  
  

  
  I EXECUTE THE FOLLOWING QUERY IN MS-ACCESS
  

  
  transform sum(SALE)
  select  CUSTOMER
  from TBL
  group by CUSTOMER
  pivot REGION
  

  
  

  
  THE OUTPUT IS:-------------------------------------
  CUSTOMER    CHANDIGARH    DELHI
  A                $100.00
  B        $100.00    
  C                $200.00
  D                $300.00
  E        $200.00    

  
  

  
  

  
  

  
  How To Do This In Sql Server

  Report abuse