Steve Jones - SSC Editor (1/15/2014)

---

Perhaps this doesn't apply to you, but to many I think it does. Too many people do half the job. Craftsmanship isn't making it perfect...

Thomas Abraham (1/15/2014)

---

Getting that balance of time invested versus quality of finished product is, IMO, one of the signs of a craftsperson. If I'm a cabinet maker, I don't worry...

Sorry Steve, but I disagree with you. I think it's a good thing that we are not craftspeople.

is NOT...

To add a little more to what previous posters have said, you should look into using sp_executesql if you are trying pass variable values between your stored procedure and the...

Koen Verbeeck (11/24/2013)

---

Tom Bakerman (11/22/2013)

---

While I'm still curious as to why my original package fails, when I change the file copies to be sequential tasks instead of parallel, the package...

While I'm still curious as to why my original package fails, when I change the file copies to be sequential tasks instead of parallel, the package runs successfully to completion.

If I'm interpreting your question correctly, an XML file on the server. No environment variables, no values from database.

Can you add a cross join to the dynamic sql? Or maybe this:

SELECT * FROM (@SQL) qry

CROSS JOIN (SELECT @a a,

Jeff Moden (11/12/2013)

---

Oddly enough, I believe that's part of the problem with delivered software, today. There's nothing like a human...

LutzM (10/8/2013)

---

If you insist doing it "in single statement", how about this:

EXEC (...).

If we'd agree this would qualify as a single statement, we're all set. Right? 😀

To "support my argument":...

It seems we've moved into the "Dating Your Employer" thread 🙂

Eric M Russell (10/4/2013)

---

The same rules that apply to dating should also apply to employment interviews. Both sides of the table should "keep it real" and not play games. The...

Ian Massi (9/27/2013)

---

Gary Varga (9/27/2013)

---

Tom Bakerman (9/27/2013)

---

...Side question: I had an interview of the latter sort where after a half hour of grilling me, the interviewer excused himself and left...

crmitchell (9/27/2013)

---

Sean Lange (9/25/2013)

---

frdrckmitchell7 (9/25/2013)

---

Thank you for your response:

I've built the (part of) query like this:

(IM.ItemCode BETWEEN '999999' AND 'CL00000'

OR IM.ItemCode NOT LIKE '001920'

OR IM.ItemCode NOT LIKE...

Having just been on the job market for 4 months over the summer (what a great time to be without a job), I can't agree more. But even before...