Top With Sums, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

DECLARE @vw_FirstRegistration TABLE
(
  Warehouse_ID INT NOT NULL
 ,SourceID INT NOT NULL
 ,firstName VARCHAR(30) NOT NULL
 ,lastName VARCHAR(30) NOT NULL
 ,firstProgramSource VARCHAR(30) NOT NULL
 ,firstProgramName VARCHAR(30) NOT NULL
 ,firstProgramCreatedDate DATE NOT NULL
 ,totalPaid DECIMAL(9,2) NOT NULL
 ,totalRegistrations INT NULL
 );

INSERT @vw_FirstRegistration
  (
    Warehouse_ID
   ,SourceID
   ,firstName
   ,lastName
   ,firstProgramSource
   ,firstProgramName
   ,firstProgramCreatedDate
   ,totalPaid
   ,totalRegistrations
  )
VALUES
  (12345, 1,'Max','Smith','League','Kid Hockey','2017-06-06',100,3),
  (12345, 6,'Max','Smith','Activity','Figure Skating','2018-09-26',35,1),
  (12346, 1,'Joe','Jones','League','Other Sport','2018-05-05',90,3),
  (12346, 6,'Joe','Jones','Activity','Other Activity','2017-09-26',35,1);
  
SELECT TOP (1) WITH TIES
  v.Warehouse_ID
  ,v.SourceID
  ,v.firstName
  ,v.lastName
  ,v.firstProgramSource
  ,v.firstProgramName
  ,v.firstProgramCreatedDate
  ,SUM(v.totalPaid) OVER (PARTITION BY v.Warehouse_ID) AS totalPaid
  ,SUM(v.totalRegistrations) OVER (PARTITION BY v.Warehouse_ID) AS totalRegistrations
FROM
  @vw_FirstRegistration AS v
ORDER BY
  ROW_NUMBER() OVER (PARTITION BY v.Warehouse_ID ORDER BY v.firstProgramCreatedDate)

View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 4, absolute service time: 0,23 sec, absolute service time: 0,24 sec