I ran the statement (OP):

grant view any definition to [Paleo-Server\SQLServerZaloha]

but the problem persists. What I want is to find the path to the database file on...

I don't think it is a missing feature - if you do think that then you should make the recommendation that it be included in the product.  You can post...

If you want to use that string with IN - as in :

WHERE column IN (@listpar)

Then formatting the string isn't going to work.  You need to parse...

Why do you need to email the report - wouldn't it just be easier to create the file and direct the users to the file?  Or - create a snapshot...

If you were on SQL Server 2016 or higher you could try automatic seeding - but since you are still on 2014 your only options are backup, copy and restore.

I...

See this link: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-master-files-transact-sql?view=sql-server-ver15

The login would need VIEW ANY DEFINITION to see anything in sys.master_files AND access to the database(s).  If the login does not have access to the databases...

As I stated before - SSMS has a defined...

I see nothing in that query that requires dynamic SQL - nor is there anything done with that table variable.  Assuming there is much more to the code than shown...

Most people won't download a word or excel document from a forum - too risky.  But - without seeing what you have my guess is the default display settings in...

It's funny that the OP didn't actually post the "last value" in what appears to be the desired report.  Where do you supposed that "last value" fits into that? ...

Also - it isn't clear how you are counting/summing the data.  How do you determine the previous quarter - for example, Q1's previous quarter would be Q4 of the previous...

What have you tried so far?  This is still just a cross-tab query - you just changed the data.

Different hardware - different OS - generating a different float value which is probably 3.275111111111111 or some other variant.

BTW - most people will not open an attachment in Word or Excel format due to the risk associated with these types of documents.  It would be much better to...

In the future - please provide sample data in the form of a create statement and insert statement.  That can be done using temp tables or a table variable.  I...