#DateForumTypeThreadPost
805 Jan 2015 @ 09:04 PSTData ModelingTopicDeleting Hi all -  I have a scenerio i need assistance with. My scenerio is as follows: I am building a snapsot table that assigns a batchid everytime it is run. These Id's are NOT necessarily in...
708 Dec 2014 @ 07:48 PSTData ModelingReplyDropping a partition...Follow up question, Dieter... If I wanted to go the route of dropping the partition, instead of doing the delete, could i compare the PARTITION level against a date? Similar to  WHERE PARTIT...
604 Dec 2014 @ 11:19 PSTData ModelingReplyDropping a partition...Thanks, Dieter!!
504 Dec 2014 @ 10:06 PSTData ModelingTopicDropping a partition...Hi All -   How would I drop a partition if i need to calculate against the current date? So far I have  ALTER TABLE XBITbls.FctBlgAcctSvcPrc_PARTITION     MODIFY ...
427 Oct 2014 @ 02:56 PDTData ModelingReplyCasting integers....Hi Dieter -  I just cant figure out how to successfully cast a VARCHAR(5) into a INT field through a select.  SELECT BlgProdInstID, AcctID, DataSrcTypeCd,    CAST(B...
327 Oct 2014 @ 02:32 PDTData ModelingTopicCasting integers....OK.... i can't seem to get this to work... im doing an insert on a table and i want to move a VARCHAR into a INT. I'm trying to CAST it, but its not working... any ideas? INSERT INTO tbl ...
222 Oct 2014 @ 08:00 PDTData ModelingTopicNested Update - Case issueHi all -  I am looking for some input on an UPDATE statement. I am still new to Teradata and looking to do an update based on certain conditions.. Below is the statement i have right now..Ple...
117 Oct 2014 @ 10:05 PDTData ModelingTopicPartitioning on a flag (column)Hi all! I m new to TD and have a question on a given scenerio. I am building a fact table and need to retain 2 days of rolling data. The architect built in a flag (Is_current), and this will be us...