I don't know might be going on. The result certainly is not expected. Could you post the output of "SELECT @@version" for your local instance?

Also, can you attach the query...

OUTER APPLY is quite similar to a LEFT JOIN. The difference between JOIN and APPLY is that when you have A JOIN B, B cannot be a query that refers...

If I am doing the code review, it will not pass...

First: stop using NOLOCK all over the place! It litters the code and it can lead to incorrect results being returned in a matter which is difficult to reproduce.

Next, if...

I don't see why the variables would be a problem. They can be dumped with PRINT and SELECT as well. No reason to replace them with something else to debug.

(And...

It's over 15 years since I gave up using an SQL debugger. I found that I spent more time to get to work than I actually got out of it....

First of all, take out those NOLOCK. You may be a gambling man, but gambling does not really have a place in database systems.

The reason you lose the rows is...

So did you try our solutions? And more to the point, did you try to augment any of them to fit this slant of the problem?

Jeff, if that is part of a SELECT list, what SQL dialect would that be? I...

SELECT ID2, SUM(Amount1), SUM(Amount2)
FROM   (SELECT ID2, Amount AS Amount1, 0 AS Amount2
        FROM   Table1
  ...

• This reply was modified 5 years, 3 months ago by Steve Jones - SSC Editor.

Indexing could help a lot! Or not at all, all depending on what your memory pressure is due to. It could be that you are scanning a 100 GB table...

If it is a web application that uses an application login, don't add users as logins to SQL Server at all. If  you already have, drop them.

TDE requires nothing special...

Please elaborate on your question. We don't know your system. Is it a web application? A fat Windows client? And what do you mean with the second sentence?

If you have a working loop for SQL 2008, stick with it. And consider my piece of code a kick in the rear parts to get you ahead for an...

By the way, thank you for proving CREATE TABLE + INSERT and even the sample data with INSERT statements. Far too few people do that.