Questions about teradata-sql-assistant
Read more about teradata-sql-assistant
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Calculating the Difference in Days Between DATE occurrences
Trying to calculate a date difference beteween two occurrences in cases (date1 minus date2 minus 1), but get the following error:
SELECT Failed. 3707: Syntax error, expected something like an 'END' ke...
Michaelle Sameer Ta Ani
Votes: 0
Answers: 0
SQL Query a table and use LPAD for one column with dtype (smallint) to return values with leading 0's
There's about 25 columns and I want to query them all while formatting this one column to include leading zeros.
i.e
julianday = 5
I want the data to show 005
julianday = 145
I want the data to show 1...
Number1Rock
Votes: 0
Answers: 1
How to get the list of teradata tables from a particular database using SAS?
I am trying to get the tables using the following proc sql statement:
proc sql;
Select tablename from dbc.tables;
run;
I have already defined the teradata and SQL server locations required. The e...
Dev
Votes: 0
Answers: 2
expected something between the beginning of the request and the 'IF' keyword error when using IF in TeraData
I am trying to make a "drop if exist" in TeraData with the following statement
SELECT 1
FROM DBC.TABLES
WHERE DatabaseName = 'test1'
AND TableName = 'test2';
IF ACTIVITYCOUNT = 0 THE...
Nicolas Pacheco
Votes: 0
Answers: 0