Well, FETCH is also an SQL statement.

Apparently this is a cursor set up in the API, and I will have to admit that I don't know how to find the...

• This reply was modified 6 years, 8 months ago by Erland Sommarskog. Reason: Missing word

So here is a lesson for you: If you want to be spoonfed a working solution, you should include a CREATE TABLE script for your table and INSERT statements with...

A correct observation Jeff, but since Briceton did not care to include anything else, I had to assume that the Transaction date is unique. If it is not, well, then...

On SQL 2012 and later:

WITH CTE AS (
   SELECT AccountNumber, TxtAmount, PrevAmount = LAG(TxnAmount) OVER (PARTITION BY AccountNumber ORDER BY TransactionDate), TransactionDate
   ...

I have a short article on my web site on this topic: Arrays and Lists in SQL Server.

Planned restarts twice a month? Well, sp_cycle_errorlog twice should be enough.

There is no setting for this. You can set how many errorlog files to retain, I believe, but there is...

I am not sure that Developer Edition is applicable here.  Jack the Cat talks about doing analysis of data. That smells production to me. And Developer Edition is not licensed...

No, that is not possible.

But you can download and install of Express Edition, which is free, to your laptop.

I agree with Chris. The query requires two indexes: one for (Column3) INCLUDE (Column2, DateTime) and one for (Column2, DateTime). The first index is required to satisfy the condition Column3...

Look at my verbal description. We want to find rows with a the same value in Column2 and where DateTime is bigger the ours. Thus, both columns need to be...

I think you need to find the person or vendor responsible for this query. Trying to tune an incorrectly written query is an uphill battle.

You should be able to get...

Before we start to talk about tuning, I like to check a more basic thing. Are you perfectly confident that the query is returning the correct result? My interpretation of...

You will typically not find calls to these sps in directly in application code, but they are generated under the covers by the client API with certain settings.

I am not...

With sample data, CREATE TABLE etc it is difficult to test.You can't expect to get working queries, but you get something to work from.

Did you try putting a SELECT before...

One advantage of having the table is that you keep the data (the account mapping) apart from the logic. But admittedly, if you have to enter new accounts manually by...