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

If you are wanting to do it manually, I believe this query should help (may want to tweak it a bit to suit your specific needs):

SELECT
 ...

Sorry for the delayed response, but that is the method I would use.  Basically exactly the code you have.

Then before you do the delete, do a quick check to make...

You would need the same logic in your delete.  Your insert and delete logic should be the same or you will either insert data that isn't deleted (resulting in duplicate...