#DateForumTypeThreadPost
609 Nov 2011 @ 12:43 PSTDatabaseReplyRows to column     Hi ,   For your use....   Alter the below based on your requirement.       WITH RECURSIVE cntry_state (country,state_nm,Fld_LEVEL) AS &...
509 Nov 2011 @ 12:11 PSTDatabaseReplyRows to column | SQL looping | reccursion    Hi,           It's a sample query to provide you some idea on the recursive SQLs to satisfy your requirement. You  can modify it based ...
408 Nov 2011 @ 05:20 PSTToolsReplyHow to identify Unreadable charecter in teradata? Hi Sachetan,         You can use the SQL like   case when translate_chk(col1 using unicode_to_latin) <> 0 then NULL else col1 end  to nullify...
303 Nov 2011 @ 12:45 PDTDatabaseReplyHelp required in query Pandeesh ,               Use the below query and check whether its satifying your conditions. SELECT       A.start_date, &nb...
202 Nov 2011 @ 10:30 PDTDatabaseReplyFormat funciton ignored from SQL Assistant Hi,    SQL assistant has its own format for Date and timestamp values. In SQL assistant , You can't see the date output in the format specified in the query while it displays. ...
115 Jul 2010 @ 02:10 PDTMarketing & CRMReplyRemainder segments are writtening to the Contact History in the TCRMHi , I hope the splits are made using the attributes and in which you used Age 18-24 and Age 25-75 as a range value. If you want to remove the remainder from using in History & mail , you c...