kabaari (1/19/2015)

---

Good afternoon all,

I have the query below and it returns zero but if I remove the first part of the WHERE clause, it works using the second half parameters....

Koen Verbeeck (1/19/2015)

---

You linked two Boolean expressions together with AND, meaning both must return TRUE in order for the WHERE clause to return TRUE.

However, looking at the first parts already...

This is a waste of CPU cycles.

Stick with Phil Parkins suggestion. Stick to the KISS principle...

Congratulations!!!

Lynn Pettis (1/12/2015)

---

Alvin Ramard (1/12/2015)

---

Lynn Pettis (1/12/2015)

---

Steve Jones - SSC Editor (1/12/2015)

---

Since I've seen a few notes, and the Thread is quiet....

Test drove a few cars over the weekend. After...

Lynn Pettis (1/12/2015)

---

Steve Jones - SSC Editor (1/12/2015)

---

Since I've seen a few notes, and the Thread is quiet....

Test drove a few cars over the weekend. After selling the 911, I'm...

This would make sense.

One way to approach this is to assign the file name to a variable as the first step inside the ForEach loop.

In your data flow, you can use...

Are you sure that spid was still active?

I strongly believe in the KISS principle. Keep It SQL Server 🙂

I had to check if the original post was from Apr 1st.

Nope. :w00t:

Differential update should...

Yes, update your resume every 2 weeks!

What error does the job report when it runs?

Recruiters are like every other type of people. There's good ones and bad ones.

Keep shopping until you find someone that's ready to work with what you want instead of...