Jacob Wilkins (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight...

Someone has been watching 'The Man Who Knew Infinity'.

MMartin1 (9/15/2016)

---

I find it clearer if AS is used consistently when aliasing anywhere. If I can...

Brad Allison (9/15/2016)

---

Yep, it looks okay. In doing further investigation and trying to trace the issue through execution results, it looks like the permissions on the destination table changed...

How odd. If you open the file in Notepad ++, does it look 'OK'?

Brad Allison (9/15/2016)

---

I have not ever seen this one and wondering if anyone has. I have a scheduled SSIS job that transforms two tsv file data and sends it...

Steven.Grzybowski (9/15/2016)

---

I wish I could. The...

Brandie Tarvin (9/15/2016)

---

Fast.Eddie (9/7/2016)

---

Good Afternoon All, This is my first post.

I created the below code and if works fine. However my DBA said "It does the job but is clunky"...

I'd be stunned/amazed if it "didn't work", but Windows Server 2016 is not mentioned on this page and therefore I guess it's not guaranteed.

Steven.Grzybowski (9/14/2016)

---

drew.allen (9/14/2016)

---

Clean up your data before submitting it to your function.

DECLARE @input VARCHAR(250) = 'abc,def,ghi,123,jkl,345,678,mno,901,234,567,pqr'

WHILE PATINDEX('%[0-9],[0-9]%', @input) > 0

SET @input = STUFF(@input, PATINDEX('%[0-9],[0-9]%', @input) + 1, 1, '')

You should...

Thanks Chris. If someone else is experiencing this problem, I hope that they find this...

Sangeeth878787 (9/14/2016)

---

Hi,

I need to create a package to move from one folder location A to another folder location B by checking whether folder exists or not. We have a table...

I try to keep...

I think you meant 'fella', rather than 'lumberjack'. Then again ...

I'm sure at least 1% of your traffic is me repeatedly reading your 'CATCH ALL QUERIES' post 😀