Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Jan 2010 @ 12:34:43 GMT

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

Subj:   Re: Workaround to avoid product join
From:   Victor Sokovin

  I am not sure if I can avoid joining the reference table only by extending the CASE though. I need the data to be grouped by every minute- slice, while the main table stores just the ID of a starting and an ending minute. Maybe I miss something here, but I don't think it will be so easy.  

Not sure what exactly you need from the reference table but the logic you have described so far is easy enough to put it in one CASE and avoid the join to the ref. table.


  <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