Is there the possibility that a user could have further sub folders in their share? For example:
DomainB\Server\ShareC\JoeBloggs\Financials\Sampledocument.ext

What would happen here if so?

Use a CTE and do a SUM of your intial group, and then do the AVG on the data within the CTE.

Without DDL and sample data though, can't...

You'd need to do it as a subquery:
SELECT TOP 2 CAST((SELECT Sales.SalesOrderID AS SalesID,
                          Territory.name AS...

You can use variables as part of your connection manager instead. If you create a variable that has an expression value of that day's file location I.e. C:\MyFiles\abc_15_02_2017.xlsx, you can...

Didn't you ask that question here? https://www.sqlservercentral.com/Forums/1841691/User-permission-to-grant-access

You have answers to that question there already, what's wrong with those? If you have further questions, you should reply...

Even if you add 24 hour clocks, you're still going to have problems if you have something last longer than a day, as you're recording no details of the start...

Guess work here, however, maybe...:
USE DevTestDB;
GO

CREATE TABLE #ActivityLog (Radio_name VARCHAR(20),
             Date_time DATETIME,
             Activity VARCHAR(30));
GO

INSERT...

Personally, my suggestion here would be to fix your data, not fix the expression for SSRS. Effectively a value of "900 Euros" is telling you two things: 1. The currency,...

Is there any reason why you have to do this in T-SQL? SSRS Matrices or an Excel Pivot Table would easily achieve this goal without having the need for Dynamic...