Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 07 Sep 2009 @ 13:52:00 GMT


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


Subj:   Re: INSERT into table with select Order by clause
 
From:   Shrihari Saraf

Hi All,

Thanks everyone for sharing such a good explanation. I try many workaround to overcome the ORDER BY issue, but I could not. Hence I change the logic in our application code by removing the ORDER BY clause. Now, I'm not using "INSERT INTO ....SELECT .... ORDER BY", I'm first fetching the records with ORDER BY and then inserting to the table using bulk insert option (which is a performance problem but can be managed).


Thanks for all your help.

Shrihari Saraf



     
  <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