I don't even come close...

Steve Jones - SSC Editor (3/2/2016)

---

SQLRNNR (3/2/2016)

---

Sean Lange (3/2/2016)

---

SQLRNNR (3/1/2016)

---

Sean Lange (3/1/2016)

---

Or even noun phases, at least according to MS. :-D:-D:-D

"The Term Extraction transformation can extract nouns only, noun phrases...

etl2016 (3/2/2016)

---

Hi,

I have a scenario SSIS --> Stored Proc.

Is there a way to error handle in such a way that if SP fails (abnormally), SSIS should gracefully...

SQLRNNR (3/1/2016)

---

So what...

SQLisAwE5OmE (3/1/2016)

---

Sean Lange (3/1/2016)

---

SQLisAwE5OmE (3/1/2016)

---

This is my breakdown of requirement.

-Check if any changes to ACTIVITY table

-Activity_Type = 'MEETING'

-Product_Code = different product codes for different programs/classes.

-Find out the Product_Code for which...

SQLisAwE5OmE (3/1/2016)

---

This is my breakdown of requirement.

-Check if any changes to ACTIVITY table

-Activity_Type = 'MEETING'

-Product_Code = different product codes for different programs/classes.

-Find out the Product_Code for which had activity

-First 2...

What version of sql server are you using? You have a lot of deprecated things going on in there. You have what appears to be a lack of normalization with...

Steve Jones - SSC Editor (3/1/2016)

---

Ed Wagner (3/1/2016)

---

Even though I don't see any sign of ever using SSIS, it's always nice to learn something new to start the day. ...

Or even noun phases, at least according to MS. :-D:-D:-D

"The Term Extraction transformation can extract nouns only, noun phrases only, or both nouns and noun phases."

I agree 100% with Kevin that this function is ridiculous. As he said this a horrible way to build a table valued function from a performance standpoint. After your insert...

Alan.B (2/26/2016)

---

Sean Lange (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get...

Lynn Pettis (2/26/2016)

---

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more candidates for...

SQLRNNR (2/26/2016)

---

Sean Lange (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Hugo Kornelis (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been stuck in my head each morning this week... Sheena Easton's...

Ed Wagner (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Hugo Kornelis (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been stuck in my head each morning this week... Sheena Easton's Morning Train. ...

MyDoggieJessie (2/25/2016)

---

Whoops, attachments added.

Yes it runs super quick using "test" data, but the original procedure can takes 20 minutes depending on how much data gets loaded into that temp table....