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

I've just had a conversation with our client about the fact that backups weren't being taken on the instance that we provide to them.  It's not strictly our problem, that's...