Yes, but ...

I'd suggest trying out a couple of non-destructive queries first ... and definitely in a test environment ... just to get familiar with it.

Note the comments about sp_msForeachDB...

Some pratting about is required to handle the single quotes embedded in your SQL, before it can be passed to an executor proc.

One way is to replace all single quotes...

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