SELECT TrId, SellPrice, kode, DiffAmt,
    SellPrice + SUM(DiffAmt) OVER (ORDER BY TrId ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Rtotal
FROM #tmp

Create some test data:

DROP TABLE IF EXISTS TestTable
GO
CREATE TABLE TestTable
(
    NoSeqTrt INT,
    NoSeqIti INT,
    idPointsrv INT
)
;
GO
-- Populate TestTable...

• This reply was modified 2 years, 6 months ago by Jonathan AC Roberts. Reason: corrected

Deleting does not directly cause a page split but after a delete there might not be enough space for a new row to be inserted, so it might indirectly cause...

I hope I don't sound too critical but that's not really true,...

Try looking up the word faster.

Ok data setup with the following rows:

insert into dbo.t1
select t.N, SUBSTRING(CONVERT(varchar(40), newid()), 1, 10)
from dbo.fnTally(1,10000000) t;

insert into dbo.t2
select...

Here is a test that shows using a separate MERGE is faster than a UPDATE/INSERT.

If you change your data to a more realistic scenario, you will come to the...

I found this to work perfectly:

  where ServiceDate between DATEADD (mm, DATEDIFF (mm, 0, GETDATE ()) - 1, 0) and 
  dateadd (dd, -1,...

I don't understand how you get to those results, can you attach the spreadsheet with some data and the formula?

Here is the code produced by ChatGPT

SELECT *
FROM your_table
WHERE date_column >= DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0)
  AND date_column...

Here is a test that shows using a separate UPDATE/INSERT is faster than a MERGE.

SET STATISTICS IO, TIME OFF

if object_id('dbo.t1','U') IS NOT NULL drop table dbo.t1;
if object_id('dbo.t2','U')...

Sorry, but this script won't work well for large tables, especially with heavy use of IN() and NOT IN() operators. MERGE is usually faster than series of consecutive INSERT/UPDATE/DELETE...

Heh... Ya think? 😀

Why is there...

Well it can't go in the Employee table.

I think you just need one table with

Overtime

ID (primary key)

EmployeeId (foreign key referencing the Employee table)

OvertimeDate

OTypeID ("D", "FoN", or "FN")

OvertimeHours