#DateForumTypeThreadPost
1220 Dec 2013 @ 03:55 PSTToolsReplyBTeq date issueThank you Deiter. I was just hoping to show the format that exist in the table without having to format.   
1120 Dec 2013 @ 07:51 PSTToolsTopicBTeq date issueHi, I am having an issue when using Bteq in Linux.  Let's say I have a table in teradata that has two columns: Article            ...
1008 Oct 2013 @ 06:39 PDTThird Party SoftwareReplyTeradata on LinuxWhy do we need to install VMWare ? I installed on my linux but can't seems to find the database.
917 Jul 2013 @ 12:17 PDTDatabaseReplyCross tab - PivotSorry, I couldn't put everything in one post. From here I just insert to Count_History  from #temp  
817 Jul 2013 @ 12:12 PDTDatabaseReplyCross tab - PivotSET NOCOUNT ON; CREATE TABLE #temp(  [table1] [int] NULL,  [table2] [int] NULL,  [table3] [int] NULL,  [table4] [int] NULL   ) ON [PRIMARY]   INSERT #...
717 Jul 2013 @ 12:11 PDTDatabaseReplyCross tab - PivotThank you Deiter. I do understand, but I need to keep my counts in a single row for all the tables for history audits. The ideal solution is if i can convert the following MSSQL server code to Te...
610 Jul 2013 @ 01:17 PDTDatabaseReplyCreating Table In Stored Procedure....Thanks a lot.  This helped me as well as I thought i had that many errors.    
510 Jul 2013 @ 11:44 PDTDatabaseReplyCross tab - PivotHi Dieter, I have a few TD tables that I needed to do rowcounts.  e.g.         count(*) from TableName. Now, the result of the count is going to a temp ta...
409 Jul 2013 @ 05:59 PDTDatabaseReplyCross tab - PivotI found my own solution. 
303 Jul 2013 @ 08:53 PDTData ModelingReplyConverting Rows to ColumnsDeiter, can you post the code for recursive?
203 Jul 2013 @ 06:35 PDTDatabaseReplyStored Procedures - Use dynamic cursor for any tableCan you post the code.  I have a table (items) with two columns etc. column A, Column B A             B item1  &nb...
125 Jun 2013 @ 12:41 PDTDatabaseTopicCross tab - PivotHI, I NEED TO DO A ROWCOUNT ON ALL TABLES ON A GIVEN DATABASE. I CAN EASILY DO THIS IN SQL USING A PIVOT TABLE. CAN SOMEONE HELP? THIS IS WHAT I HAVE: LETS SAY THIS IS (TABLE_COUNTS) ...