Anybody? Can anybody please step in again and try helping me with WC? Frustrated, can't seem to get him to realize I just don't know what he is...

Welsh Corgi (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing...

Welsh Corgi (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted...

What is really frustrating is not getting the whole picture of what someone is trying to accomplish and feeling like you are pulling teeth from a chicken when asking questions...

Lynn Pettis (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted value so I need...

Would help if you posted the code you used and...

Eirikur Eiriksson (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

TomThomson (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Steve Jones - SSC Editor (7/16/2014)

---

GilaMonster (7/16/2014)

---

Jeff Moden (7/15/2014)

---

To be honest, I'm glad this person is taking such caution and has...

TomThomson (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Steve Jones - SSC Editor (7/16/2014)

---

GilaMonster (7/16/2014)

---

Jeff Moden (7/15/2014)

---

To be honest, I'm glad this person is taking such caution and has such FUD about it....

Welsh Corgi (7/16/2014)

---

I need to add to a Data Transformation task to Load to Staging.

I need o update the existing record to the encrypted value so I need to add...

Looking at the documentation for ENCRYPTBYKEY you may want to change the data type of your encrypted SSN from char(9) to something like varbinary(128). Play with the size of...

I am glad to see others jumping to help WC. I thought there was an article on SSC that actually covered this as well but my Google-fu isn't working...

matfurrier (7/16/2014)

---

Friends, I got the result we needed.

I created this script and it was extremely functional.

Many thanks to all who helped.

Hugs

SELECT

DISTINCT P.ITEMID,

RECENTES.OC,

RECENTES.DIMENSION3_

,(SELECT SUM(P2.QTYORDERED)

...

Jeff Moden (7/15/2014)

---

You're right. Pork chops won't work there. Has...

What InvoiceDate do you want displayed? Looking at a supplier with multiple entries there are different Invoice Dates.

And I left mine back in the States. Didn't want to chance losing it here in Afghanistan.