Viewing 15 posts - 1 through 15 (of 29 total)
You should be able to replace your "select *" with a delete command. See below.
begin tran
delete from PD7333.F980351 WHERE VRPDI ='R590012' AND VRVERS = 'DETEST01';
-- commit
-- rollback
After you have verified...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 15, 2011 at 10:46 am
That's a great idea, as long as the criticism is honest (sometimes brutally honest) but constructive and as long the manager is actually receptive and opened to the feedback given...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
April 29, 2010 at 10:28 pm
How to handle the stress? Not sure... but my way of dealing with it is: "keep things in perspective". I am not saying I take my job lightly. In fact,...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
January 20, 2010 at 10:12 pm
Agreed with Steve about avoiding the blaming game and being supportive of each other regardless of where the issue comes from. But I have to also agree with IceDread concerning...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
January 7, 2010 at 8:53 am
I am there with some of the other comments: performance tuning skills (reading Grant Fritchey's paper), build better monitoring scripts (and find a nice way to display them to my...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
December 31, 2009 at 6:44 am
Very nice writing skills. Bravo!
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
December 28, 2009 at 9:46 am
Thank you Scott. I appreciate the feedback and perspective.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
December 23, 2009 at 8:28 am
I work for a very small company that almost did not make it through the recession. We went down from about 20 developers, a full team of business analysts, architects...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
December 23, 2009 at 6:27 am
That's perfect. Thank you very much.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
October 24, 2009 at 9:40 pm
Lutz,
This looks perfect! I will make sure in the future to try listing all possible scenarios so that the community can test them all. I really love the fact that...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 23, 2009 at 4:15 pm
Lutz,
I understand your concerns. I ran the original script you posted with the following set of transactions and found some issues related to transactions showing up in the table even...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 23, 2009 at 2:53 pm
First of all, I wanted to thank all of you for the help. I reused the original portion of the script posted by Lutz in my real life project but...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 23, 2009 at 1:48 pm
Lutz,
I just wanted to clarify the terminology of the comments column, which purpose was simply informational and not to be used in the actual process.
> fully used: means that the...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 22, 2009 at 12:32 am
Thanks to all of you for the replies. I had a busy father's day weekend but I will look at the post as soon as I can. Thanks again.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 22, 2009 at 12:11 am
I modified the code sample. I had forgotten about the amount column in the bundle group table, which is the reward amount allocated when a bundle match is found. The...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
May 22, 2009 at 1:03 pm
Viewing 15 posts - 1 through 15 (of 29 total)