Tags for select
Performance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insert
Team,   We have an insert statement that is inserting around 92 million records into a table based on a select statement from another table.  The select piece runs fine, but the following step takes a long time. We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767.
insert select merge table multiset identity
Using fields form SELECT block in QUALIFY block
Hello! Teradata allows to use fields from SELECT block in other blocks.  A have two tables T1 and T2. And there is a field "a" in table T1 and in T2. And i made a new field in select block^ SELECT  case when T1.a > T2.a then T1.a else T2.a end AS a  
select sql qualify
using update with WITH clause
Hi,   I'm trying to do something like below, but its giving me syntax error, can anyone please tell me what is the issue and how to fix this.   with cte0(ID,int_col1) as(     select row_number() over (order by (select 1)) AS ID,int_col1 from shuffletest ) update cte0 set int_col1=ID;  
with database query update select function row number
Using result of HELP column within a query
Hi, while searching for a possibility to get the datatype of the columns of a view I came
Select Statement inside a case statement
Hello,   I am facing a problem when writing a case statement,  Here is the sample query
case select sql teradata
Pipe delimited fast export file
Hi, I am exporting a large amount of data into a file.The specification is like each column should be seperated by pipe.If there is no data,there should be space.(| |) I need file in this format if there is data it should be like this
fast export select file space null export pipe delimiter teradata
How to use JDBC FastExport with R
The following shows how to select rows from a database table using JDBC FastExport, which only works with JDBC PreparedStatement.
r jdbc preparedstatement select fastexport
Minmum Time field selection - TIME(6)
Dear All, I have a Table where i have 2 fields - date_col and time_col. DATE_COL - DATE FORMAT 'YY/MM/DD' TIME_COL - TIME(6) I am trying to select the min(time_col) for a particular date / current_date... When i select all the records from the table for a particular date, i can see the min of time_col is '00:01:33'
time timestamp conversion Minimum Value select
SELECT INTO SQL inside stored procedure
Hi All, I have the following SQL inside a stored procedure file and need some help.  I don't have access to the database so I can't test it out.
sql select into stored procedure
Row Number and Select Distinct Query
Good morning TD community,
distinct row_number select