Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 23 Jan 2010 @ 23:46:22 GMT

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

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

  It's not lost, the cumulative sum takes care of that, it carries the previous value over to that minute.  

I agree with this but I thought that the "missing" minute should also contribute to the usage for all sessions alive during that minute, not just copy the usage from previous minutes.

Don't understand how the SUM (or double SUM) can handle this if it gets cnt=0 for all "missing" minutes. Perhaps some extra COUNT is still necessary?

Again, "missing" minute is the one which can only come from the last query in the UNION. It does not occur in A.

Suggest we wait until the OP gets back to the discussion and confirms.


  <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: 23 Jun 2019