Steve Jones - Editor (3/23/2009)

---

Lots of soccer talk, and good to talk to. Hopefully...

foxjazz, I am more than willing to help here, but I am not writing a line of code without the sample data and expected results. I need something to...

Linson.Daniel (3/23/2009)

---

Hey FoxJazz,

I couldnt really read through all the posts..but from what I have understood , ur requirment seems to be that from the set of records having the same...

Good, but still lacking. Some sample data and expected results would be the icing on the cake. That would allow us to validate our code before posting back.

Please...

RBarryYoung (3/23/2009)

---

So what's Lynn really like in person? Can you actually see the...

Also, looking at your initial post, you only provided the DDL for two of the tables in the query. Really could use the DDL for the other two tables....

First question, does the following query return the correct result set that you are deleting items based on?

SELECT distinct

Application.ApplicationID,

ApplicationProduct.ProductControlID

FROM

...

The only "table" that is being created is a table variable. You should be fine using this script.

If you have the cursor based code for doing this, it would help if you posted that as well. It will answer questions that will make rewriting in a...

kevin.l.williams (3/23/2009)

---

I know why the null value is not returned but I am puzzled by the explanation.

"Since col2 is used in the WHERE clause, the output does not include the...

I should mention that I also got to meet Steve Jones last week at the Colorado Springs SQL Server Users Group meeting. He was down doing a presentation. ...

mtassin (3/23/2009)

---

r.hensbergen (3/23/2009)

---

I like these questions a lot more than making 'SQL puzzles', just by showing bad code. Your question is a typical sample of what I run into daily....

You can use an Execute Package Task to execute another package, but I'm not sure about calling a specific task within another package.

I do agree with you Gus, I think that is why The Thread is probably still alive. This one has been very entertaining and has allowed many of us...

Bob Hovious (3/22/2009)

---

Vaguely serious, non-beer question.

I just kidded Lynn about chastising someone for hijacking "the rant", because it had already been briefly hijacked by a discussion of incrementing next...