Bravo. Gave me too much of a headache before my first coffee trying to work that out.

If you find that you cannot run this as a distributed transaction, it should be possible...

ramos.ferdinand (10/24/2016)

---

Hi Gurus,

Just wanted to seek out for your help. This is a bit opposite of what aggregation should be. :hehe:

I wanted to aggregate records with different values and...

philand3 (10/23/2016)

---

Dear All,

i would like to send out following query to all email users daily basis,can anyone guide me the direction,

it can be from SQL or external tool,ETC.

SELECT ...

You've just found a pretty good example of why SELECT * is often regarded as bad practice.

Usually, I would suggest that you specify all of the column names explicitly. But...

Super_Grover (10/23/2016)

---

Phil Parkin (10/23/2016)

---

Super_Grover (10/23/2016)

---

It is unique AFAIKS but it's not an unbroken sequnece. In other words: it does not stay in sync with the row...

Super_Grover (10/23/2016)

---

It is unique AFAIKS but it's not an unbroken sequnece. In other words: it does not stay in sync with the row numbers (doc_numbers are...

Is doc_number unique?

Jeff Moden (10/21/2016)

---

Just to be sure, ol' friend... please don't ever take my sometimes (usually?) zealous contrarian attitude towards SSIS personally. Without boring you with the ugly details, I...

Is anyone experiencing the effects of this?

http://gizmodo.com/this-is-probably-why-half-the-internet-shut-down-today-1788062835

And Catalog.Packages in...

chocthree (10/21/2016)

---

All, I thank you for each of your responses. Much appreciated.

Ok, here is the deal. I'm a little long in the tooth and have done some VB6/C# development ten...

sqlfriends (10/21/2016)

---

I have a table for example called ServiceCase, it has a closedDate. Meaning if the case status changed to something means end of the case, then it should mark...

Jeff Moden (10/21/2016)

---

Phil Parkin (10/21/2016)

---

Jeff Moden (10/21/2016)

---

Phil Parkin (10/20/2016)

---

Jeff Moden (10/20/2016)

---

Phil Parkin (10/20/2016)

---

Jeff Moden (10/20/2016)

---

Phil Parkin (10/20/2016)

---

First point to note is that a CSV file is a far far better...

Jeff Moden (10/21/2016)

---

Phil Parkin (10/20/2016)

---

Jeff Moden (10/20/2016)

---

Phil Parkin (10/20/2016)

---

Jeff Moden (10/20/2016)

---

Phil Parkin (10/20/2016)

---

First point to note is that a CSV file is a far far better thing to be importing...