Keep it simple

DECLARE @sample TABLE
        (
              ...

Are you sure? I am summing at the lowest level, converting hours to minutes.

Then I am reverting the sum back to hours and minutes (for the sample data 29 hours...

• This reply was modified 3 years, 2 months ago by SwePeso.
• This reply was modified 3 years, 2 months ago by SwePeso.

DECLARE @sum INT;

SELECT  @sum = 60 * SUM(CAST(PARSENAME(REPLACE(x, ':', '.'), 2) AS INT)) + SUM(CAST(PARSENAME(REPLACE(x, ':', '.'), 1) AS INT))
FROM    (
  ...

IF DATEPART(DAY, SYSDATETIME()) = 1 AND DATEDIFF(DAY, '19000101', SYSDATETIME()) % 7 = 6
BEGIN
    EXEC dbo.WhatEver;
END;

• This reply was modified 3 years, 4 months ago by SwePeso.

https://www.sqltopia.com/algorithms/date-and-time/jdedwards/

DECLARE @Sample TABLE
        (
                Account...

You can substitute this simple GREATEST with a CASE WHEN THEN END statement.

SELECT          StudentId
FROM            @student
GROUP BY   ...

-- swePeso solution
WITH cteData(StudentId, delta, rnk)
AS (
        SELECT  StudentId,
          ...

• This reply was modified 3 years, 6 months ago by SwePeso. Reason: Added DISTINCT just in case there are multiple streaks with 3 days or more

Because if you care about performance, you want to avoid IO.

Calculating "next wednesday" is about 150 times faster than looking it up (using ta table) on just a few million...

https://www.sqltopia.com/algorithms/date-and-time/get-the-nth-weekday-of-any-interval/

https://www.sqltopia.com/unix-timestamp/

SELECT  fcustno,
        fnamount,
        finvdate 
FROM    dbo.armast
WHERE   fcustno...

What about the dimensions not in the fact table?

SELECT          a1.businessid,
        ...

Something like this?

        WITH cteAggregated(CustomerID, ItemID, Yak)
        AS (
    ...