No need to apologise Pietlinden, especially when you've just taught me something too.  I didn't realise running totals had become so straightforward.

However.... The OP's after a solution that...

If there is no way to establish the order of the rows this can't be done properly.  If you don't know what value is first then second and so on...

Ok, that's better but it's still not hugely clear.

Are you adding all three tables together for all ID's?  You appear to have used ID 1 for all your...

There's not a lot to go on there. There's a huge number of reasons why your report isn't returning anything.  You'll need to provide much more detail to get a...

This is known as the 'Double-Hop Problem' and there's a lot of information out there.  It essentially boils down using Kerberos to pass the client's credentials from one server to...

DECLARE
    @TimeTo DATETIME = '2018-07-15 10:11:12'
    ,@TimeFrom DATETIME = '2018-04-01 09:03:27';

SELECT
    CAST(DATEPART(YEAR,startM) AS CHAR(4))
    +'-' + CASE
                WHEN DATEPART(Month,startM) <10
                    THEN...

It's a funny old world; I noticed that somebody had 'liked' this post I made four years ago, almost to the day.  When I made it there was a lot...