36 | 17 Jun 2015 @ 07:31 PDT | Tools | Topic | Two minor issues concerning TDSQLA 14.10.0.02 Functionality | Hello,
"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... |
35 | 10 Jun 2015 @ 05:19 PDT | Database | Reply | Various UPDATE Scenarios | Repost.
Any ideas would be appreciated.
Thanks and God Bless,
Genesius
|
34 | 15 Apr 2015 @ 09:53 PDT | Database | Reply | Decrease Time to Run Large UNION Statement | Both,
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... |
33 | 13 Apr 2015 @ 10:18 PDT | Database | Reply | Decrease Time to Run Large UNION Statement | Update.
My mistake.
TPRD.TMA = 5,103,949,241 rows
TPRD.GT = 204,469,116 rows
Thanks and God Bless,
Genesi... |
32 | 13 Apr 2015 @ 08:22 PDT | Database | Topic | Decrease Time to Run Large UNION Statement | The 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... |
31 | 04 Mar 2015 @ 07:26 PST | Database | Reply | Various UPDATE Scenarios | Hello.
Is this question not proper for this forum?
Thanks and God Bless,
Genesius
|
30 | 26 Feb 2015 @ 12:05 PST | Database | Topic | Various UPDATE Scenarios | Hello,
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... |
29 | 18 Nov 2014 @ 09:07 PST | General | Topic | Calculating for a 45-Day Grace Period | I 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... |
28 | 14 Nov 2014 @ 10:09 PST | General | Reply | Select 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 &... |
27 | 10 Nov 2014 @ 12:52 PST | General | Reply | Select 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... |
26 | 07 Nov 2014 @ 12:50 PST | General | Reply | Select 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, ... |
25 | 29 Oct 2014 @ 04:33 PDT | General | Reply | Select 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
|
24 | 28 Oct 2014 @ 12:38 PDT | General | Reply | Select 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... |
23 | 28 Oct 2014 @ 10:07 PDT | General | Reply | Select 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... |
22 | 28 Oct 2014 @ 06:02 PDT | General | Reply | Select 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... |
21 | 27 Oct 2014 @ 10:07 PDT | General | Reply | Select 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... |
20 | 23 Oct 2014 @ 01:03 PDT | General | Reply | Select 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.
... |
19 | 23 Oct 2014 @ 10:15 PDT | Tools | Reply | TDSQLA 14.10 - Cut & Paste Issue | Mike,
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
|
18 | 21 Oct 2014 @ 12:55 PDT | General | Reply | Select 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... |
17 | 21 Oct 2014 @ 10:30 PDT | General | Reply | Select 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... |
16 | 21 Oct 2014 @ 05:36 PDT | General | Reply | Select 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... |
15 | 20 Oct 2014 @ 01:00 PDT | General | Topic | Select 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... |
14 | 07 Oct 2014 @ 05:45 PDT | Tools | Reply | TDSQLA 14.10 - Cut & Paste Issue | Hi.
Has anyone experienced the same issues with cut & paste?
Thanks and God Bless,
Genesius
|
13 | 25 Sep 2014 @ 06:22 PDT | Tools | Topic | TDSQLA 14.10 - Cut & Paste Issue | Hello,
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... |
12 | 08 May 2014 @ 11:42 PDT | General | Reply | Errors When Loading XML Data | There is a typo above.
SOSXML is supposed to be SYSXML.
In the running code this is correct throughout.
Thanks and God Bless,
Genesius
|