#DateForumTypeThreadPost
1120 Dec 2007 @ 02:05 PSTToolsTopicUsing Teradata SQL in ASP.net 2.0I am trying to code in ASP.net but am having problems getting "select where" statements and "update" statements to work.For Update, I get the following Error:Exception Details: System.Data.Odbc.Odb...
1022 Aug 2006 @ 11:45 PDTDatabaseTopicHow do I make an exact copy of a current tableAny Ideas?Can I just Create Table 1 as(Select * from Table 2)
903 Aug 2006 @ 01:01 PDTDatabaseReplyTop FunctionThis worked great. Thanks for the help. It's a bit of a spool hog, but that's another issue entirely...
831 Jul 2006 @ 04:04 PDTDatabaseTopicTop FunctionIs there an equivilant to the Top function in Teradata?MS syntax select top 5 * from TABLEX order by 1
730 Jun 2006 @ 09:35 PDTDatabaseReplyHow do you declare a variable in Teradata SQL?Here it is in sample format:--step 0 This step create variables so I don't have to look through the code and worry about the dates I'm working withCreate volatile Table TEMP As (Select'1060401' (i...
629 Jun 2006 @ 11:57 PDTDatabaseReplyIs there an Equivilant Function to Execute in Teradata.Ok that was a poor example. I am actually trying to do something more likeExecute ('create table '|| temp.tablename|| ' yadda yadda' where I'd create a different table per month and increment the t...
529 Jun 2006 @ 11:47 PDTDatabaseReplyHow do you declare a variable in Teradata SQL?I needed a couple variables for a start date and end date for a long stretch of code to make it more easily reusable. I settled for making a single row volatile table which holds these start and en...
427 Jun 2006 @ 11:12 PDTDatabaseTopicIs there an Equivilant Function to Execute in Teradata.This is How I would write this in MS SQL SERVER 2003, how would I do this in Teradata. I mean use the Execute function. -- drop table temp;Create volatile Table TEMP As (Select'1060101' (int) star...
327 Jun 2006 @ 09:48 PDTDatabaseTopicHow do you declare a variable in Teradata SQL?First of all, I am new, and I am not sure where to post basic Teradata SQL questions.Anyway, outside of a SP, I am writing a long piece of code which I would like to use some variables in, but I ca...
223 Jun 2006 @ 03:09 PDTAnalyticsReplyCreate Volatile Table not working with TrimThanks Dieter. As an Aside, while it did not work in Create AS, if I create the Table seperately, and Insert, it works fine...
123 Jun 2006 @ 12:46 PDTAnalyticsTopicCreate Volatile Table not working with TrimI am trying to create a volatile table with the following slection criteria.CREATE VOLATILE TABLE DSL3 AS(Select BTN (CHAR(13)) BTN, Case When substr( trim(BILLED_CITY_STATE) ,(length (...