You should find that this[/url], by Aaron Bertrand, allows you to do it.

Please post a copy of the execution plan.

Martin Schoombee (6/7/2016)

---

Hi Phil,

The best way is with a calculated measure, using a case statement to check if the sum (or aggregate) is less than zero.

It would also be possible...

jcobb 20350 (6/7/2016)

---

I have a nightly job that sends out a csv file to our supplier. They then upload the data from there. The problem is that the field length...

Jacob's answer is clear.

To illustrate his point about appropriate indexes, try creating this and then running the query again:

CREATE INDEX x ON #T2(D1) INCLUDE(A1);

I suspect that the question is: "Why does the Execution Plan for this query contain a 'sort' when there is no ORDER BY clause?"

If so, the answer is along the...

SQLTougherGuy (6/6/2016)

---

Luis - The command-line that I provided will be executed from SQL Agent. From what my boss has told me, re engineering these Oracle packages to SSIS is going...

SQLTougherGuy (6/6/2016)

---

Hello,

I need to execute a bunch of Control-M Oracle jobs and packages using POWERSHELL. These jobs will be scheduled using SQL Agent. I have the following code (see...

Any Oracle users out there who are keen to move to SQL Server? This may be of interest.

kokilaeb (6/5/2016)

---

Can someone please help on a Oracle PL/SQL code which will compare each column in 2 similar structured (similar data as well and one tend to change wherein I...

"all the .csv files" ... in the world? In your...

Just tried installing 2016 Dev on a W7 machine, only to get this:

I hadn't realised that W7 was not supported. So now ... W10 upgrade on a Friday ... why...

You need it to loop for every day between MaxDate and GetDate()? Why not just return the number of days (between MaxDate and GetDate()) from your ExecSQL and use that...

Kyle Sherry (6/2/2016)

---

I checked those settings and already had SET QUOTED_IDENTIFER check boxed. I added this SET command at the top of the script and it executed in SQL Server...

The CREATE script for the People table should also show you which setting is required.

By default, QUOTED_IDENTIFER should be ON.