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...

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...

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,...

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...

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...

Very nice writing skills. Bravo!

Thank you Scott. I appreciate the feedback and perspective.

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...

That's perfect. Thank you very much.

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...

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...

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...

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...

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.

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...