#DateForumTypeThreadPost
422 Mar 2010 @ 07:23 PDTDatabaseReplyDay Of Week or Week-Ending Function?Join Sys_Calendar.Calendar (it should be populated) calendar_date DATE UNIQUE (Standard Teradata date) day_of_week BYTEINT, (1-7, where 1 = Sunday) day_of_month BYTEINT, (1-31) day_of_year ...
318 Mar 2010 @ 07:00 PDTDatabaseReplyAlternative to count(*) in TeradataAnother way: if the table has a USI and collected statistics on that index, you can do a HELP STATS DATABASENAME.TABLENAME and look at Unique Value column. Remember: It is not a 100% value (you ne...
218 Mar 2010 @ 06:50 PDTDatabaseReplyBest way to compare contents of two tables?I think that the code below could help you. SEL A.TABLENAME TABELA_DESTINO, A.COLUMNNAME COLUNA_DESTINO, A.COLUMNFORMAT TIPO_COLUNA_DESTINO, COALESCe(B.TABLENAME, A.COMMENTSTRING) TABE...
118 Mar 2010 @ 06:44 PDTDatabaseReplyDELETE query is taking too long time in the production....Please, paste both table definition. And the table demographic too. This query really takes 19 minutes? Have you tested it yet?