Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Jun 2007 @ 21:23:15 GMT


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


Subj:   Extradcting and Ordered list of Values present in a single column
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, June 26, 2007 08:38 -->

I am trying to extract an ordered list of values that are present in a single column.

For example, DBC.TVFields captures the list of compressed values for a specific attribute in one attribute: CompressValueList.

If the contents of the CompressValueList are ( 16, 34, 7, 9, -23, 123, 99, -16, 42, 17), I want to pull them out as (-23, -16, 7, 9, 16, 17, 34, 42, 99, 123).

I am hoping someone has a SQL solution to this in their pocket that may be shared.

Failing that, some fresh thoughts are welcome.


Thanks



     
  <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: 27 Dec 2016