Tags for columns
Retrieve columns having a specific value
Hi, I have 100+ columns. I need to retreive columns having a specific value [Say 'ABC'] in any of the rows.  Please help. 
columns value
Concatenate Columns value ordered
Hi, I have a table that looks like this: Column1 Column2 Column3 800 900 200 500 300 40 100 600 150 and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns: Result 200,800,900 40,300,500 100,150,600
concatenate columns order
Concatenate Columns value ordered
Hi, I have a table that looks like this:   Column1 Column2 Column3 800        900        200 500        300        40 100        600        150   and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:   Result
concatenate columns
Concatenate Columns value ordered
Hi, I have a table that looks like this:   Column1 Column2 Column3 800        900        200 500        300        40 100        600        150   and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:   Result
concatenate columns
comparison of 2 columns of different datatypes giving undesired results
  Greetings All,   When comparing 2 different char/varchar datatypes in TD , the comparison is returning undesired results as the hexadecimal representation of the data in columns is different eventhough the data is visibly same.  Not sure what the "00" in the  hexadecimal notation represents.   
compare columns different datatypes
CompressValueList add blank spaces in DBC.Columns field
Hi all, I'm writing here because I didn't find any previous entry that solve my strange problem. 1) I define a table that has a column with COMPRESS clause
columns dbc dictionary compress compressvaluelist create sql
How to find the number of columns in each table in Teradata ??
teradata find number of columns table
Get DDL from DBC tables
Hi everyone, I'm tryng to build a set of queries with the objective of getting the DDL of tables only from the info inside the dbc tables (columns, tvm, dbase, tableconstraints...). I started from the table dbc.columns to get all the info about every field of a table. Below you can find the work in progress query.
ddl dictionary dbc format columns
Need to convert Rows to columns
Hi Guys   I'm facing a difficulty in achieving the below scenario   Scenario : Table A is the table i'm having ( The column ID2 has only 4 distinct values -- A,B,C,D )  
rows columns rows to columns
Index stats vs Column stats combo , Multicolumn stats and judicious stats collection strategy
Good Day Folks... 3 Q's bunched up on stats ... <> When should you collect Index stats  and column stats for the component columns , both as against just Index stats. How does index stats help and how does stats on component columns that make up the Ix help 
statistics optimizer index cpu columns collection

Pages