valmostricay (8/30/2016)

---

Today I have worked in sql server 2014, I saved all changes in my database and closed it. Couple hours ago I opened it again and showed an error:...

Nice post, Frederico. Good points, well made.

There is more than one syntax error here (I thought you'd done...

afreenraja (8/29/2016)

---

Thanks for your quick response.

Please find my answers:

Which table does the ordertype column live in? Exp

Are you summing the sale column from the sale table, or does Exp have...

dan.brown1 (8/29/2016)

---

Hi,

In my Prod & Non-Prod, we use a stored proc to pull a list of rows. In non-prod sql server, query completes in 2seconds but in prod it would...

pedro.imex (8/28/2016)

---

a) Identifying the statement(s) which generate the error(s)

$query = "UPDATE lc_t_configuracion SET valor = '$valor' WHERE id_conf =$id_conf ORDER by id_conf DESC LIMIT...

Welcome to SSC.

We're not PHP programmers here, so please help us out by

a) Identifying the statement(s) which generate the error(s)

b) Cutting and pasting the exact text of the error...

Eric Mamet (8/28/2016)

---

A colleague told me that there is Analysis Services in SQL Server 2016 standard edition, though with capacity limits.

Is that true?

Or is it still necessary to get...

SteveD SQL (8/28/2016)

---

Hi Phil

The scenario I am trying to deal when importing data from a flat. End result is if any of the data in the flat file is invalid,...

SteveD SQL (8/28/2016)

---

Hi Phil,

Thanks for the input. Yes I think I am going to a RAW file mainly because I discovered while there is a Record Set Destination there is...

SteveD SQL (8/28/2016)

---

Hi,

Is it possible to...

1) create an empty, no rows, Object Variable from a table structure. Possibly with a SELECT * FROM XYZ where 1=2

2) Add records to the...

komal145 (8/26/2016)

---

Also , since you worked on Excel source. I have a question , my excel source always looks for test files which i pointed in excl connection manager...

Grant Fritchey (8/26/2016)

---

Phil Parkin (8/26/2016)

---

Steve Thompson-454462 (8/26/2016)

---

Grant Fritchey (8/25/2016)

---

Eirikur Eiriksson (8/25/2016)

---

Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do...

Steve Thompson-454462 (8/26/2016)

---

Grant Fritchey (8/25/2016)

---

The...

Have you done this?