#DateForumTypeThreadPost
3617 Jun 2015 @ 07:31 PDTToolsTopicTwo minor issues concerning TDSQLA 14.10.0.02 FunctionalityHello,   "Clicking any cell in the SQL Statement column in the History window copies the SQL to the Query Window." I have lost more unrun/unsaved code by clicking the SQL Statemen...
3510 Jun 2015 @ 05:19 PDTDatabaseReplyVarious UPDATE ScenariosRepost. Any ideas would be appreciated. Thanks and God Bless, Genesius
3415 Apr 2015 @ 09:53 PDTDatabaseReplyDecrease Time to Run Large UNION StatementBoth, The GROUP BY will not work as I am not using Aggregate Functions. balachandra, Won't the UNION ALL give me duplicates? Now I need code to delete the dups. sravan4, I ran your fi...
3313 Apr 2015 @ 10:18 PDTDatabaseReplyDecrease Time to Run Large UNION StatementUpdate. My mistake. TPRD.TMA = 5,103,949,241     rows TPRD.GT   =    204,469,116     rows   Thanks and God Bless, Genesi...
3213 Apr 2015 @ 08:22 PDTDatabaseTopicDecrease Time to Run Large UNION StatementThe following code takes approx 13-14 hours to run. Is there anyway to improve this on the coding side, before I approach our DBA's? Here are the sizes (number of rows) for each of the table...
3104 Mar 2015 @ 07:26 PSTDatabaseReplyVarious UPDATE ScenariosHello. Is this question not proper for this forum? Thanks and God Bless, Genesius
3026 Feb 2015 @ 12:05 PSTDatabaseTopicVarious UPDATE ScenariosHello, I have been checking the Internet for the syntax for the UPDATE statement. It seems there are many different ways to write an UPDATE statement and I am confused by the various examples...
2918 Nov 2014 @ 09:07 PSTGeneralTopicCalculating for a 45-Day Grace PeriodI adopted the following code from a former employee in my department. What I need to do is create a table with only the valid BillPeriods in it. BizCode is CHAR(8) Bgn_Dte and End_Dte , which ar...
2814 Nov 2014 @ 10:09 PSTGeneralReplySelect data from one row, while on another row in the same table.Thanks Dieter. Here is the final code that calculates everything I need. CREATE TABLE TDWSTAGE.NJSACECalendar ( /*t1*/  YoC INTEGER,  DoY INTEGER,  DueDate DATE FORMAT &...
2710 Nov 2014 @ 12:52 PSTGeneralReplySelect data from one row, while on another row in the same table.Dieter, When I was riding the bus home on Friday, I thought about performing another JOIN. Without the code in front of me I wasn't sure what to do. Also, you are correct, YofC and DofY are in...
2607 Nov 2014 @ 12:50 PSTGeneralReplySelect data from one row, while on another row in the same table.I thought I was done with this calendar, but no. Now I need to include another NewDueDate, but for the previous month. Here is what I have written so far, but I am stuck.  WITH cte (YofC, ...
2529 Oct 2014 @ 04:33 PDTGeneralReplySelect data from one row, while on another row in the same table.I didn't notice the duplicate column names. Now I know. Thanks Dieter, for all your help. You have given me a lot to work off of. Take care, and God Bless, Genesius
2428 Oct 2014 @ 12:38 PDTGeneralReplySelect data from one row, while on another row in the same table.Dieter, I did not refresh my Internet Explorer, so I did not see your post an hour before mine about the 2666 error. I believe it finally works! However, along the way I found an anomoly that I h...
2328 Oct 2014 @ 10:07 PDTGeneralReplySelect data from one row, while on another row in the same table.Dieter, I don't have time to test right now, but it appears like this line of code ON SCC.Calendar_Date = HC.Holiday that is causing the error. I copied it from the posting here, and did n...
2228 Oct 2014 @ 06:02 PDTGeneralReplySelect data from one row, while on another row in the same table.Thanks Dieter. That stopped the 3706 error. Now I have another. "2666 Invalid date supplied for NJSHoliday.Holiday." Below is the full code I am runnning. I am posting this here now (so I...
2127 Oct 2014 @ 10:07 PDTGeneralReplySelect data from one row, while on another row in the same table.Thanks Dieter. When I run the above I received an error: "SELECT Failed.  [3706] Syntax error: expected something between ')' and the 'AS' keyword." CTE is con...
2023 Oct 2014 @ 01:03 PDTGeneralReplySelect data from one row, while on another row in the same table.Thanks Dieter, Now I need to come up with an OLAP to handle a 45-day grace period end date for the same calendar. I modified your code as follows, but I do not get the results I was looking for. ...
1923 Oct 2014 @ 10:15 PDTToolsReplyTDSQLA 14.10 - Cut & Paste IssueMike, I did not receive an email notifying me that there was as response to my question. Thanks. We have our sys admins looking into this. God Bless, Genesius
1821 Oct 2014 @ 12:55 PDTGeneralReplySelect data from one row, while on another row in the same table.Dieter, Did some research, because I think I need to do something with the ROWS function. I think this works; still have to test further. SELECT   SCC.Day_of_Year,   SCC.C...
1721 Oct 2014 @ 10:30 PDTGeneralReplySelect data from one row, while on another row in the same table.Dieter, Your code almost produced what I was looking for. Unfortunately, the new due date for Fridays that are not a holiday are being changed to the next Monday. Also, the new due date for M...
1621 Oct 2014 @ 05:36 PDTGeneralReplySelect data from one row, while on another row in the same table.Dieter to the rescue. ;-) I am going to try this, but first let me finish my original post, so that it will be clear for future viewers. This is what a portion of the table looks like. CalD...
1520 Oct 2014 @ 01:00 PDTGeneralTopicSelect data from one row, while on another row in the same table.Hi. No longer a newbie, but still need help. I have a table based on our corporate calendar. I created this by joining the SYS_CALENDAR and a calendar table of our Due Dates.  I created...
1407 Oct 2014 @ 05:45 PDTToolsReplyTDSQLA 14.10 - Cut & Paste IssueHi. Has anyone experienced the same issues with cut & paste? Thanks and God Bless, Genesius
1325 Sep 2014 @ 06:22 PDTToolsTopicTDSQLA 14.10 - Cut & Paste IssueHello, I can no longer call myself a newbie (2 year anniversary with my job), but I am still green on some issues. I searched this site - as well as the Internet - and could not find an answ...
1208 May 2014 @ 11:42 PDTGeneralReplyErrors When Loading XML DataThere is a typo above. SOSXML is supposed to be SYSXML. In the running code this is correct throughout. Thanks and God Bless, Genesius

Pages