That sounds like a pretty easy task:

WITH cte AS (
SELECT [RANGE], [STATUS], LAG([DATE]) OVER (PARTITION BY [ID] ORDER BY [RANGE]) AS [PrevDATE]
FROM <table name>
)
UPDATE [cte]
SET [STATUS]='Y'
WHERE [RANGE]='001'...

• This reply was modified 6 years, 4 months ago by Mr. Brian Gale. Reason: Code cleanup - was pulling data that is never used

My recommendation would be to try it out.  You are licensed for it; give it a shot.

Build up a proof of concept data migration and compare it to the C#...

I have only had budget laptops with upgraded parts (such as an upgraded drive).

My HP Envy was problematic from day 1.  Had a stuck pixel.  Got it returned under warranty...

My next thought on things to check would be the IIS logs.  If the PBI logs look fine, it is likely something in your IIS logs.

As a random guess (as...

The resulting data type in your calculation is Numeric. I am thinking it is probably a floating point precision error that is giving you a near but slightly lower than...

That really depends on what you are trying to do.  If it was me, and just guessing based on a lot of the variable names and trying to eyeball that...

What about something like this on your last query:

DECLARE
    @i_from_date DATE = '2019-10-10'
    , @i_to_date DATE = '2019-10-10';

WITH [object_changes]
AS
  ...

I think this falls under an "it depends" window. What problem are you trying to solve?  Is a single customer complaining about performance?  are multiple clients? are all clients?  are...

While I do agree with you, I've seen strange behavior like that before.  I cannot think of or provide a case where it happened, but I've seen where performance improves...

Hello keneangbu,

My first piece of advice would be remove the cursor.  Cursors are inherently slow.  In your sample piece of code, I do not see a nice way to kill...

Just because it works in 1 browser doesn't mean it is not a configuration issue.  Each browser may interpret the redirect differently or may even be ignoring it.  I've been...

Error 5 is access is denied.  My first step would be to check what user the SQL Server service is running under and make sure that account has permissions.

If this...

Going over to scdecade's solution and doing a bit of tweaking to it, would this not work:

DROP TABLE IF EXISTS test_table;
GO
CREATE TABLE [test_table]
(
    [projectid]...

When I am installing SQL Server on a server, I usually copy the contents of the DVD to the machine.  This allows me to install new instances quickly and easily...

I believe powershell can handle that, but most setup applications have silent options so powershell may be overkill for it.

That being said, I would be more concerned about why your...