Steve Jones - SSC Editor (9/9/2014)

---

david.wright-948385 (9/9/2014)

---

Deadlines can be achieved even on a complex project if:

...

4 if the total estimate is too big, the deliverables or the...

Jeff Moden (9/8/2014)

---

adonetok (9/8/2014)

---

Is it possible to pass entire where sentence to a store procedure?

From app, I'll generate a where sentence like below:

where orderID = '123' and orderCidy='London'

I created a...

Steve Jones - SSC Editor (9/8/2014)

---

Certainly people need some training, though I understand companies being reluctant to train people too much as the investment might not pay off if the...

opc.three (9/8/2014)

---

lvbntapasvi (9/6/2014)

---

Hello All,

I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the...

This might be a good time to start stealing concepts from neighboring disciplines. There are lots of templates and standards around capturing reliability analysis results and potential issues. ...

jkalmar 43328 (8/26/2014)

---

Nope. That deleted the rows I wanted to keep and left the ones I wanted to delete. Fortunately I ran it against test data.

I want to KEEP PL1....

Gary Varga (8/26/2014)

---

Jeff Moden (8/25/2014)

---

TomThomson (8/25/2014)

---

If you want code working and out of the door quickly, there's only one way to do it: first spend enough effort understanding requirements and...

Jeff Moden (8/24/2014)

---

Steve Jones - SSC Editor (8/24/2014)

---

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do...

Eric M Russell (8/20/2014)

---

Gary Varga (8/20/2014)

---

Eric M Russell (8/20/2014)

---

When traveling outside the US, especially to a country with a State Department travel warning, you should consider leaving your smart phone...

I really wouldn't be tossing around that 1099 sole proprietorships and S-Corporations are the same. There are some fairly dramatic differences which will come back to bite you if...

Sorry if we're being tentative - but de-duping tends to be tricky, especially when using phone # as the basis. I keep staring that this one - and am...

lsalih (8/11/2014)

---

I ran the query against real data, and noticed the query does not take into account relationship_type. For example, mother and father can both have same phone. In that...

By the way - you fix that by setting the "delay validation" property of...

Unless you plan on getting tremendously fancy with your SSIS projects, just use the precedence constraints. If you have steps X and Y and you drag the "green arrow"...

One word of caution: based on the filtering being done - you will get inconsistent results if you run the query multiple times. As in - since your query...