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.

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  

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;  

Hi, while searching for a possibility to get the datatype of the columns of a view I came

Hello,   I am facing a problem when writing a case statement,  Here is the sample query

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

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'

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.

Good morning TD community,