![]() |
Hi. I googled about :END_DATE but nothing came up. WHERE CAST( IDX.START_TXN_DATE AS DATE) BETWEEN :END_DATE - (104*7)-6 AND :END_DATE
14 Dec 2015
| 1 comment
,
|
![]() |
Hi All,
26 May 2015
,
|
![]() |
I’m trying to do a test stored procedure on using volatile tables. This is what I have:
19 Mar 2015
| 3 comments
,
|
![]() |
I am trying to create new variables using a combination of text and numbers. I thought this was possible but do not know for sure. I am getting the following error dont know if its because im missing something simple or the way im trying to concatenate is fundementally incorrect. The query ran exactly as desired prior to adding the concatenated fields.
11 Jan 2015
| 4 comments
,
|
![]() |
Hi,
26 Oct 2014
| 11 comments
,
|
![]() |
Hello all,
06 Feb 2014
| 2 comments
,
|
![]() |
How do I combine multiple Select queries? I have 7 queries run separately. Each query return 2 columns. Count(of something), (date) Date Range is Fixed for each query Set to 1 Week only.
15 Aug 2013
| 10 comments
,
|
![]() |
Hi all, I am trying to select a column that has a max length of 5. If the data in the column has less than 5 characters, I pad spaces to the end of it to make it 5. In SQL, the select is written: SELECT LEFT(Column + ' ', 5) FROM Table What would the equivalent in Teradata be?
18 Apr 2011
| 4 comments
,
|
![]() |
I am troubling over this error as I am not sure what the cause might be. Any help would be greatly appreciated. select Id, (select
31 Mar 2011
| 20 comments
,
|
![]() |
I'm a Teradata newbie. I want to create tables with NO PRIMARY INDEX. I am on version 12.0. My DDL looks similar to this. CREATE MULTISET TABLE UP_KWADA.TEST_INSERT, FALLBACK, I get the error message
08 Jun 2010
| 3 comments
,
|
![]() |
Hi, I've just arrived to the Teradata world from SQL Server and learning the new syntax. How do you update a table using a join? The first approach I used was what I have been doing: create aliases, then refer to them, but I get 3993: Illegal use of alias name.
17 Jul 2009
| 2 comments
,
|