#DateForumTypeThreadPost
1706 Nov 2012 @ 11:58 PSTDatabaseTopicNeed help with selecting distinct event date within last 180 days  Select A.SubscriberKey,COUNT(DISTINCT EventDate) AS Count,B.CreatedDate From _Open A JOIN _ListSubscribers B ON A.SubscriberKey = B.SubscriberKey Where B.ListID = '10...
1622 Aug 2012 @ 05:24 PDTDatabaseReplyInsert data into table with data imported already Thanks for the clarification.
1522 Aug 2012 @ 05:02 PDTDatabaseTopicInsert data into table with data imported already So this is probably a dumb question, but if I have a table that I have already imported data into, and I want to insert more data, will the previous data be overwritten? I want to import another...
1424 Jul 2012 @ 01:29 PDTDatabaseReplyUpload error - import completes but doesnt import any of the columns data I did not send a commit work and session mode is Teradata....
1324 Jul 2012 @ 08:00 PDTDatabaseTopicUpload error - import completes but doesnt import any of the columns data I am trying to import a file that contains the folowing information. I ahve tried it both as a txt file and csv file. Also have gone into "options" to make sure columns are sepreated b...
1213 Jul 2012 @ 11:28 PDTDatabaseReplyFastLoad Error when trying to import... Error fixed. Thanks guys
1112 Jul 2012 @ 01:15 PDTDatabaseTopicFastLoad Error when trying to import... Hello Everyone, I am runnning into the error -> Query Failed. Refer to result column in History for details. <- Here is the script that I am running. Any suggestions? ] DROP TABLE ...
1026 Jun 2012 @ 07:16 PDTDatabaseTopicSQL Syntax to show last 90 days subscribers added....Is this correct way?? Select EmailAddress, CreatedDate From _ListSubscribers Where ListID = 10630 AND CreatedDate > (Select DATEADD (day,-90,getdate()))
925 Jun 2012 @ 01:06 PDTDatabaseReplySQL to drop last four digits from a 9 digit zip code I never thought of it that way. Brilliant!!
825 Jun 2012 @ 11:42 PDTDatabaseTopicSQL to drop last four digits from a 9 digit zip code Hello everyone, I need some help figuring out how to drop the last four digits of a 9 digit zip code. If I have a list of subscribers with a couple hundred thousand that have zip codes withe...
721 Jun 2012 @ 08:52 PDTDatabaseReplyCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form??? Thanks!!
621 Jun 2012 @ 08:31 PDTDatabaseTopicCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form??? Here is what I have that is causing the error........   CREATE MULTISET TABLE DLAB_MARKETING.Click, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFA...
520 Jun 2012 @ 11:54 PDTGeneralReplyAre Column headers needed to import in CSV format? The error that I keep getting is {Query contains 1 parameters but Import file contains 0 data values} I am importing a CSV file...I have already went into the options-import/export and chang...
420 Jun 2012 @ 11:37 PDTGeneralTopicAre Column headers needed to import in CSV format? I am trying to import some data and it keeps giving me a format error. Is this because I am not including the column headers? Thanks for the help!
319 Jun 2012 @ 12:29 PDTDatabaseReplyConverting CHAR to DATE What does the (6) in the parenthesis indicate?
219 Jun 2012 @ 12:08 PDTDatabaseReplyNew to Teradata To start.....What kind of data will you be accessing? It is hard to give you advice on tpes of structure for tables when the data type is unknown.
119 Jun 2012 @ 10:07 PDTDatabaseTopicNeed help importing date format I need some help as to how I can import a .csv file with the date format as MMDDYYYY so that it changes to YYYYMMDD. I know you can do a INSERT INTO table.name function and add the FOR...