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...

lindsayscott23 (10/21/2016)

---

Grant Fritchey (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

Lins,

I think you misunderstand what Grant meant by cross-database querying.

If you separate out the data into individual databases, how many queries will have to touch...

Azure Blob Storage is completely separate from SQL Server Editions, as...

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 from than an Excel...

komal145 (10/20/2016)

---

hi,

i created several pacakges which runs sql and load dat to a table. and all the packages are in the different steps of a job. If any of the...